All about RollbackSnapshotTempDB…

  I’ve been recently involved in several cases where Databases named RollbackSnapshotTempDB +<someGUID> were generating confusion. The purpose of this post is to clarify their origin and use and to enable SQL Server admins to know what to do if they need to deal with them. The following topics will be discussed (click for a…


Service status watcher in SQL Server Management Studio – How it works

Have you ever wondered about the mechanism using which SQL Server Management Studio(SSMS) – Object Explorer shows the service status for SQL Server and SQL Agent service? We recently worked with a customer on a issue related to this and thought that this might be useful information to share out. So here it is. Here…


DBMail has Suddenly Stopped Working

  The other day we ran into a strange Database Mail issue here in SQL support. Customers were running into issues where DBMail would suddenly stop working after doing service pack upgrades to their SQL Servers.This was happening on both SQL 2005 and SQL 2008. The error was also unusual in that the word “timeout” could make…