How to run an .exe file from stored procedure?

Question

How to run an .exe file from stored procedure?

Tariq Saeed Ansari

SSC Enthusiast

Points: 122
More actions
January 17, 2006 at 1:00 am

#90440

Hello,
I have a situation where I have to run an exe file through a stored procedure or using some sql query.
I tried using master..xp_cmdshell 'myprog.exe' but I get the message that

'myprog.exe' is not recognized as an internal or external command, operable program or batch file.
Please guide me if I am doing something wrong here. And if there is another way to achieve this result please tell me.
Thanks
Bye

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 1

You need to specify the full path to myprog.exe, or have it in the path environment variable (for the account SQL Server is running under).

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

Tariq Saeed Ansari SSC Enthusiast Points: 122 More actions · Answer 2

I am specifying the complete path like,

Exec master..xp_cmdshell 'd:\myclient.exe'

but it is still giving the same message

Thanks

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 3

Is D:\myclient.exe a path that exists on the server, i.e. not your client computer?

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

AndrewMurphy SSCertifiable Points: 5586 More actions · Answer 4

Even more important....DON'T try to run an EXE via a SP.....you're lining up some bad problems for yourself. SP's can't run/launch interactive EXE's and you could overload your server. I've read advice (here and elsewhere) to support this....a search should turn up the relevent items.