467,915 Members | 1,318 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,915 developers. It's quick & easy.

How do I send notifications to an external program?

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
  • viewed: 1331
Share:
1 Reply
ck9663
Expert 2GB
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.

Similar topics

47 posts views Thread by Richard Hayden | last post: by
4 posts views Thread by My SQL | last post: by
reply views Thread by Elhanan | last post: by
4 posts views Thread by windypower | last post: by
2 posts views Thread by =?Utf-8?B?YmFzaA==?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.