I have a situation where I want to be able to send an email using
"execute msdb.dbo.sp_send_dbmail" when something has gone wrong with the
validation in the trigger.

Unfortunately if I raise an error and rollback the transaction, the email
does not get sent.

Is there another way to send the email?

Travis.

Travis Crow (noreply (AT) invalid (DOT) org) writes:
This is because sp_send_dbmail queues the mail on a Service Broker queue
which is transactional.

You could to things in this order:

1) Rollback
2) Send mail
3) Raiserror




--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx