Calling an executable file from stored procedure

Hi people.

I have this issue

I'm on a application server and i need to run a executable file from a SP, my problem is if i use xp_cmdshell (from the SP) it will try to run it on the SQL Server not on a App server, this a third party executable so cannnot be run on the sql backend.

Do you know any workaround for this?have the client launch it on it's own.

what business does the server have launching apps on the client anyway?|||jez,

you never call a report engine or a command line DOS thingie from you application code?|||Hi people.

I have this issue

I'm on a application server and i need to run a executable file from a SP, my problem is if i use xp_cmdshell (from the SP) it will try to run it on the SQL Server not on a App server, this a third party executable so cannnot be run on the sql backend.

Do you know any workaround for this?

Is this executable a GUI? If so, don't do it...it could hose everything

If it's just like a bat file, or a batch process then you should be fine|||Actually is a exe file with some parameters (not GUI)

Picture this

Server A
Application Server

Server B
SQL Server 2005

on Server A, i'm executing a SP wich is located on Server B if i use xp_cmdshell is going to look on server B but the exe file is located on server A... can i do like a Remote Execution?|||Why wouldn't you place the executable on both servers?|||won't work the executable on the SQL Server by itself, i need to install the whole application and we don't have the license for it.|||Can't your xp_cmdshell just include the complete path to the executable?

as in xp_cmdshell '\\MyRemoteServer\MysteryJob\DoSomething.bat' works fine where I live.

Worst case you could have your bat file start the exe. We do some of that, though it's too close to 5:30 on Friday for me to make a decent effort at finding the applicable code at this time.|||jez,

you never call a report engine or a command line DOS thingie from you application code?

sure, but that's not how I read the question.

how I read it was, "how do I launch an exe that lives on the client from a stored procedure on the server?"

perhaps I misinterpreted.