• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 244
  • Last Modified:

Calling external program from SQL Server

How can I call an external program from within a trigger in SQL Server?  I need to pass several parameters.  Please provide specific syntax. Thank you.
1 Solution
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you can use the xp_cmdshell stored procedure (SQL Server 2000).

some sample :
exec xp_cmdshell 'C:\app\app.exe /f=1 /t=3 '
Anthony PerkinsCommented:
The following questions are considered abandoned, please attend to them:
1 03/14/2006 0 Working - Award additional points to que...  Open Suggestions
2 03/22/2006 500 ODBC to SQL much slower than MS Access -...  Open Microsoft SQL Server
3 04/19/2006 250 listbox removeitem method not supported  Open Microsoft Access

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now