xp_cmdshell to run VBS file
Hi, I am trying to use xp_cmdshell to run a VBS file on a SQL server (ver 2000). The command I am running in query analyzer is
EXEC master..xp_cmdshell 'CScript "H:\PM_Apps\GP-TEST\LTS.vbs"'
I am getting this error:
Input Error: Can not find script file "H:\PM_Apps\GP-TEST\LTS.vbs".
I have verified that the file exists in that path by opening it in a notepad and it exists.
I know that xp_cmdshell runs as the SQL server agent account and the account has full access to this folder.
I am not sure why I am getting this error. Please advice.