Run EXE from Stored Procedure

Question

Post reply

Run EXE from Stored Procedure

getshir

SSC Veteran

Points: 225
More actions
September 22, 2008 at 4:26 pm

#198370

Hi,
Is any way to run any EXE file from SQL Server 2000 >> Stored Proc
Thanks

Viewing 14 posts - 1 through 14 (of 14 total)

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

Jason Crider SSCertifiable Points: 6019 More actions · Answer 1

Might want to put this in a SQL Server 2000 forum, but here's a head start:

http://www.codeproject.com/KB/database/xyprocedure.aspx

MCITP, Database Administrator
A hodgepodge of Information Technology and Life
LinkedIn Profile
My Twitter

Bhuvnesh SSC Guru Points: 59351 More actions · Answer 2

include following script in your Stored Proc

declare @sqlcmd varchar(200)

SET @SQLCmd = 'copy c:\dba\sampl.xls c:\dba\sampl_2.xls'

EXEC master..xp_cmdshell @SQLCmd , no_output 🙂

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

RBarryYoung SSC Guru Points: 143329 More actions · Answer 3

getshir (9/22/2008)
Is any way to run any EXE file from SQL Server 2000 >> Stored Proc

XP_CMDSHELL is all you need.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

giri_engg2001 SSC Enthusiast Points: 168 More actions · Answer 4

master..xp_cmshell

executed above command ..

query result shows me..query executed succesfully..but file is not copied

RBarryYoung SSC Guru Points: 143329 More actions · Answer 5

You do realize that this executes on the Server and not on the Client, right?

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

parth83.rawal SSCommitted Points: 1858 More actions · Answer 6

Hi,

I have an EXE file which i would like to run, what i am doing is running following script but in void.... 🙁

declare @sqlcmd varchar(200)

SET @sqlcmd = 'WinWSSList.exe'

EXEC master..xp_cmdshell @sqlcmd

Now what it gives me as output is :

'WinWSSList.exe' is not recognized as an internal or external command,

operable program or batch file.

NULL

What to do ??

Thanks

Parth

RBarryYoung SSC Guru Points: 143329 More actions · Answer 7

parth83.rawal (10/2/2009)
Hi,
I have an EXE file which i would like to run, what i am doing is running following script but in void.... 🙁
declare @sqlcmd varchar(200)
SET @sqlcmd = 'WinWSSList.exe'
EXEC master..xp_cmdshell @sqlcmd
Now what it gives me as output is :
'WinWSSList.exe' is not recognized as an internal or external command,
operable program or batch file.
NULL
What to do ??
Thanks
Parth

It's telling you that it cannot find this exe file. Be sure to include the path to this EXE. And remember that this is executed on the Server, and not on your Client.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

parth83.rawal SSCommitted Points: 1858 More actions · Answer 8

Hi,

First of all thanks for the prompt reply.

My EXE is in C Drive only, and it is running fine, if i run from the command prompt.

and my server and exe both are on server only. some how it is not running.

Thanks

Parth

Al-279884 Old Hand Points: 383 More actions · Answer 9

try using full path of the executable. So instead of

SET @sqlcmd = 'WinWSSList.exe'

use

SET @sqlcmd = 'C:\WinWSSList.exe'

@sqlcmd session may open a command prompt somewhere in the binn folder of the SQL where your executable does not exist.

RBarryYoung SSC Guru Points: 143329 More actions · Answer 10

parth83.rawal (10/2/2009)
My EXE is in C Drive only, and it is running fine, if i run from the command prompt. and my server and exe both are on server only. some how it is not running.

What makes you think that the xp_cmdshell process's starting directory is "C:\"? It probably isn't, which is why should try what I suggested and specify the full path.

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

gauthamakula SSC Journeyman Points: 77 More actions · Answer 11

Do you till have this problem?

'WinWSSList.exe' is not recognized as an internal or external command,

operable program or batch file.

NULL

By this statement, I understand the 'WinWSSList.exe' cant be executed from Command Prompt.

Try executing this from command prompt.

Regards,

Gautham Akula

parth83.rawal SSCommitted Points: 1858 More actions · Answer 12

indeed it is working from command prompt but not working from SQL, 🙁

and then i changed my approach.....but still i would like to know the answer for that. 🙂

Thanks

Parth

nigel. SSChampion Points: 11636 More actions · Answer 13

Run this:

xp_cmdshell 'dir c:\*.exe'

Do you see your executable listed?

Nigel
How to post questions