I would like to get SQL Server event alerts via e-mail. I have set up database mail and operators, along with several severity alerts and a few alerts for specific error numbers. To test the alerts I have run a query in SSMS that is missing the '*/' on a comment (error 113, severity level 15). I've also tried a SELECT statement on a non-existent table (error 208, severity level 16). Interestingly, I do get mail when I set up a performance condition alert (I used tempdb > 0 KB). This tells me that the database mail is set up correctly. I have verified that the alert is enabled, and that the Notify Operators box and the operator e-mail box are both checked. Any thoughts?
