Triggers and Email

[MColeman]

Does anyone know of any problems that may be created by sending email with a trigger?

My project has a requirement that an email be sent after an update of a table.

I am uncomfortable putting an email inside of a trigger. My instinct would be to have the trigger add an entry to
another table, then have a scheduled DTS pick up these table entries and send the email.

 

[JayKusch]

The second method is more advisable. Plus you get an added benifit of a history table of events and when you mailed them off.

Thanks

J. Kusch

 

[mrdenny]

Agreed. The second method is much more advisable.

Another benifit would be that you can stop the system from sending email if you need to. And then start the email sending back up later on. For maintenaince on the email server for example.

Denny

--Anything is possible. All it takes is a little research. (Me)