calling a windows application after a record is inserted

[manasap]

Hi!

Is it possible to make a windows application run automatically after a record is inserted into a table?Just like a trigger raises after insertion,updation or deletion,i need to run a windows application after insertion.Could anyone please guide me.

Cordially,
Manasa P

 

[giadich]

yes, you can have a stored proc call a windows app/batch file by using xp_cmdshell. Be sure to read up on security with regards to using this command.