Trigger for execute exe When inserted a receode to table
-
Why! What a horrendous design, and it comes back to why would someone saddle themselves with such a nightmare! You need to do as the error suggested, add a notifyicon to your service that will live in the tray, this is the path to a UI, services do not have a UI!
Never underestimate the power of human stupidity RAH
-
If this structure is now suitable please suggest me something different. I need to fire a alarm when the data row inserted to the particular sql table.
Where is the alarm going to be consumed, on the server! Why not have a trigger spit send an email via sql mail or write an app that send a text message. Most orgs either lock down the table so only authorised people have access or use email alerts.
Never underestimate the power of human stupidity RAH