I know it's been several years since you posted this but I want to thank you, nonetheless. I spent two days working on SQL triggers and email notifications. I was working on SQL Server 2005/2008. I learned the hard way that the same stored procedures aren't present in SQL 2000. This article was very thorough and listed everything step-by-step. Thank you!