xp_cmdshell - batch file

[TheJFM]

Hi

I need run a batch file located on the E: drive of the server on which SQL server is installed.


I have tried xp_cmdshell 'E:\myfile.bat'

However the ouput indicates that the system is searching for the file in C:\WINNT\system32 and not in the directory I specified.

Any ideas?

 

[MaffewW]

Does the same command work from the command line? Any mapped network drives on the server?

 

[TheJFM]

It works from the command line with no problem