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?
-
-
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
Comment