Oh and btw SQL 2005's database mail is now asynchronous therefore we no longer have the same issue in 2005.

Need to be pretty careful with this trigger.

Consider if the call to exec master.xp_sendMail .... fails.

This is a trigger - an error will cause an automatic rollback of the transaction...