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.