Recently, I was asked why e-mails would mysteriously not be sent from one of the servers that I help maintain. One of the greatest things about working with SQL Server is most everything that happens in the server is data and all I had to figure out is where the data was stored. In msdb … Continue reading Database Mail Failed Items Log
Month: June 2008
Database Edition msdb Sample Database Projects
I've been working with Database Professional a little bit more these days. One of the databases that I've been working on for a while provides a number of diagnostic features that utilizes some msdb stored procedures. Fortunately, going forward I can stop ignoring the systax errors that occurs because of those cross-database references. The Visual … Continue reading Database Edition msdb Sample Database Projects
CLR_AUTO_EVENT Wait Stat
I've was reviewing wait stats the other day and kept finding this wait stat peaking out the other wait stats by a few hundred milliseconds. Oh my! Should I care or not... well long story short is that if all of the CLR assemblies are created in safe mode there is no problem. Or at … Continue reading CLR_AUTO_EVENT Wait Stat
Transfer Logins Between SQL Server 2005 Instances
I've never been a fan of the SQL Server 2005 Integration Services task for transferring logins between servers. It seems that I always misconfigure it or something gets missed. And when I just want to move a single login its more effort to setup the task than it is worth. What I'm really saying here … Continue reading Transfer Logins Between SQL Server 2005 Instances
Strate SQL 