I was able to use this:
>
>master..xp_cmdshell 'bcp pubs.dbo.authors out c:\test.txt -c -Ssql2000 -T'
>
>-Mike
Mike,
I am having a similar problem with network related access.
I am running 'master..xp_cmdshell 'bcp select ... out \\remoteserver\sharename\outputfile.txt -T'
The same command executes in a local drive, but when the remote server name is used, I get the error: SQLState = S1000, NativeError = 0
The SQL server account is a LOCAL account (with no access to the remote server), but I execute this job with a domain account (user name/password), which has access to the remote server. Does the job still execute under the SQL server account, or the domain account I am running it with?
Thank you,
Aristotle