Auto Notification for certain events in your Application.

If certain events occur in your SQLServer database, you can schedule a procedure to notify of specific changes in your tables and/or views. Basically, after creating the notification procedure, you can create a query of what you would like to monitor. When certain records meet your criteria, the procedure will use the xp_sendmail procedure in SQLServer to send a notification to whomever you want. Example Code is given for a database name of msdgen with a user name of msdgen.