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
|