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.

Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish