Hi,
I need to run a batch file on a remote server--testserver, so I first assigned a domain account with local admin rights to sqlservice on both boxes and then used xp_cmdshell and rcmd to run that command like this:
exec master..xp_cmdshell 'rcmd \\testserver c:\test.bat'
However, I always get this error : Error:8 - Internal error = 109
Can someone tell me what's wrong?
Thanks in advance.