I need your help.
I am using this from inside my SP to output to a data file
EXEC master..xp_cmdshell 'bcp xdatabase..h837x out C:\FileExtract.txt -c'
It works fine, EXCEPT I am ending up with random hex '200D0A's in the output file. These appear as separate lines.
Can anyone explain how they got there and what I need to do to get rid of them?
Thanks in advance.
Phil Krieg