SQL Server: Can I Use EXEC To Run An External Application?

Hello and thank you for your time, I have been searching everywhere online for an example, where a SQL trigger will run an external application, but I have had no luck. All I am s

Solution 1:

Complementing the answer on that post. I would never call another app from sql. Several reasons for that, since security until the fact that someone may move the app and you would need to update your trigger, which means you are responsible for the direct communication between trigger and app.

What I would do is make your trigger write to a table and then have a process that monitors that table (reads and delete rows) and than calls the application. I know you have another player but is safer and easier to maintain.