Help needed for SQL XP_CMDSHELL

[gundugadu]

Guys,

 

I am trying to run an following .exe from sql query 

"C:\ABCD\EFG.exe" 1234

1234 is the parameter

When running above command using below SQL getting an error

SELECT      @CMDSQL='"C:\ABCD\EFG.exe"  '+ 1234

EXEC xp_cmdshell @CMDSQL

OUTPUT:

'"C:\ABCD\EFG.exe" 1234' is not recognized as an internal or external command,
operable program or batch file.

 

 

Any help plzzzzz

[Suhaas]

Bro, this could be due to the location of the file. 

Instead of "C:\ABCD\EFG.exe" try "ip address\drive$\app.exe"

Example: 10.34.12.35\C$\ABCD\EFG.exe