December 26, 2003 at 11:28 am
Hi:
I'm new to SQL Server and I need some advise.
My question: Is it possible to trigger an external program after a table has been updated? If it is, how can I do it?
TIA
December 26, 2003 at 11:34 am
You can by placing an xp_cmdshell in the trigger, but be careful. The trigger will not complete and the transaction will not complete until the program finishes, which means locks and other resources can be held. IMHO, this is an extremely bad practice. Instead, store some value in another table and then use a job that runs every xx minutes to run the external program.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 26, 2003 at 9:25 pm
Hi:
Thank you, info much appreciated, Regards
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply