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.
Who is Participating?
Guy Hengel [angelIII / a3]Connect With a Mentor 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.