Database Mail Configuration Error 264

As most of you know, the Database Mail feature in SQL Server 2008 is the life blood of any notification system for your instances. If Database Mail fails to send notifications, you may not be warned if a job fails, or worst, a backup job. We had a server last week that was exhibiting a weird behavior within Database Mail. I was receiving mail from all parts of the Database Mail environment except for Agent Job Notifications. I was able to send test emails from Database Mail, able to receive maintenance plan summary reports and even receive emails from within maintenance plans using the notification task. Why was Agent Job Notifications the only area that was mis-behaving? As I started diagnosing the issue I checked the main areas that usually stumped me in the past: ...

January 22, 2012 · 2 min · Doug Purnell

2011 was the year of #SQLFamily

As the name suggests, SQL Family feels like family. There is no other professional organization in the world that supports a product line as well as #SQLFamily. My introduction to #SQLFamily was in the summer of 2011 when I decided to get back into SQL Server full-time after going to the dark side, management, for the two previous years. I had a strong background in SQL Server 2000 & 2005 but not the full-time experience under 2008 & 2008 R2. ...

December 31, 2011 · 3 min · Doug Purnell