Home Forums SQL Server 2008 SQL Server 2008 Administration Create DML trigger for single table in SQL 2008 and send email alert to group RE: Create DML trigger for single table in SQL 2008 and send email alert to group

  • April 11, 2013 at 9:05 am

    #1605636

    Steve Jones - SSC Editor (4/10/2013)

    In 2008, you should have queueing. DB MAil uses Service Broker under the covers, so I wouldn't worry about that.

    http://msdn.microsoft.com/en-us/library/ms190307.aspx

    +1 Database Mail in 2005+ uses Service Broker so sending an email is analog to inserting a row into a table. The actually sending occurs later, asynchronous to the request to send the email.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato