Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
stored procedure to lauch another program
- Thread starter kramers
- Start date
Here might be something that you need although you need to register to download the source code for this.
- Thread starter
- #3
This is what I did in the event anyone should care. 
CREATE PROCEDURE [Print Report] (@filename VARCHAR(400)) AS
Begin
Declare @command varchar(400)
set @command = 'master..xp_cmdshell ''"c:\Program Files\Adobe\Acrobat 7.0\Reader\acrord32.exe" /p /h ' + @filename + ''''
exec (@command)
end
CREATE PROCEDURE [Print Report] (@filename VARCHAR(400)) AS
Begin
Declare @command varchar(400)
set @command = 'master..xp_cmdshell ''"c:\Program Files\Adobe\Acrobat 7.0\Reader\acrord32.exe" /p /h ' + @filename + ''''
exec (@command)
end
- Status
Similar threads
- Locked
- Question
- Locked
- Question