Home Forums SQL Server 2005 Development How to access c:\Program files\..... in master..xp_cmdshell in T-sql RE: How to access c:\Program files\..... in master..xp_cmdshell in T-sql

  • Put the whole path to the executable in double quotes. If you have a 32-bit parameter, put it in double quotes as well.

    You also need to have the program installed on the server, not on your desktop. Remember, the query is executed on the server. Make sure your path is correct and that the SQL Server service account has permission to run the command, including whatever network resources you use in the command.

    Once you get the command working in a command prompt window and security is good, you should be able to run the command from SQL Server.