store procedure using system account -
08-29-2005
, 06:07 AM
USE master
EXEC xp_cmdshell 'copy c:\sqldumps\pubs.dmp \\server2\backups\sqldumps',
NO_OUTPUT
I run above SP but did not work ... I have the right to access server2 but
the server2 running my command use of system account that is virtual and i
cannot grant it right ... how can I specific the server running the command
use of my account or a valid account ...
Executed as user: server2\SYSTEM. |