Hi,
Trying to use xp_cmdshell to copy/rename a file.
the command is a simple copy x y statement, eg:
copy \\servername\tasc\TASC_EXTRACTS\tasc.csv \\servername\tasc\TASC_EXTRACTS\EDRS_STROKE_2003_05_29.csv
exec master..xp_cmdshell @cmd_to_be_run, NO_OUTPUT
returns
Msg 50001, Level 1, State 50001
xpsql.cpp: Error 997 from GetProxyAccount on line 472
Using:
Microsoft SQL Server 2000 - 8.00.534 Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 3)
Please help