Home Forums SQL Server 2008 SQL Server Newbies How have Trigger's example after insert send to mail on outlook?. RE: How have Trigger's example after insert send to mail on outlook?.

  • February 4, 2013 at 1:25 am

    #1583823

    Hey seiyak2009, what happens when the business just decides to record the oil price every 5 seconds due to a new fast trading platform introduced at the company? Your trigger is now sending thousands of emails crashing both SQL and the Exchange server.

    Don't send emails from triggers. Use a procedure which can be configured for a set time interval to check the oil price table, then generate an email. (I'd also hesitate sending any non critical alert emails from SQL itself. Business functionality should not be built in the data layer.)