|
rikleo2001
Posting Yak Master
New Zealand
180 Posts |
 Posted - 04/18/2007 : 22:00:49
|
Hi Guys,
I have an EXE file which I want to execute it from Stored proceudre along with some input parameters.
How do I acheive this?
I tried this but didn't work
ECLARE @DBName SYSNAME
DECLARE @cmd Nvarchar(1000)
DECLARE @Path VARCHAR(100)
declare @result int
set @Path = 'D:\GeoGauge\'
SELECT @cmd = 'myexe.exe ' + @Path + 'abc.txt' + ' ' + @Path + 'xyz.dat'
EXEC @result = master.dbo.xp_cmdshell @cmd
Any ideas?
SKR |
|
How to Execute External Application
