By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,414 Members | 1,586 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,414 IT Pros & Developers. It's quick & easy.

How do I send notifications to an external program?

P: 1
I know that SQL Server can automatically generate emails in response to things, but is there a more generalized capability that I can use to tell a seperate program running on the PC that the contents of a table have changed without simply querying the table over and over again?
Oct 8 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 2,878
Depends on what kind of program. That program should always be running and listening to the SQL Server for it to know that SQL Server have sent something.

You can also create a trigger that will send you an email that a table has been modified. You'll receive as many email as the updated records.

You can also create a trigger that updates a table. Then you have a job that checks that table every 10 minutes to send you email or run an external program to inform you of changes.

-- CK
Oct 8 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.