From: noreply@invalid.org   
      
   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.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)