Posted by Neil Webb on 05/18/06 11:14
I'm trying to copy files between 2 servers on a local network from within a
SQL Job (and Query Analyzer) using xp_cmdshell.xcopy but get an access
denied message returned.
I'm able to successfully do the copy from within a command window so think
the problem has something to do with using the default SQL Server account
but as yet I don't know how to resolve.
Any help/suggestions would be much appreciated.
Navigation:
[Reply to this message]
|