blog community

Browse by Tags

• Clustering
• Errorlog
• SQL 2005
• SQL Agent

• Detecting if DTC is running

  I've recently worked on a fix for one of our jobs that starts when the SQL agent is started and proceeds to contact a central server to report the new node the instance is running on. The problem is that sometimes the MSDTC isn't running when Read More... Posted Friday, March 14, 2008 11:35 AM by BertrandR | 0 Comments Filed under: Clustering, SQL 2005, SQL 2000, SQL Agent

• Reading the SQL errorlog

  Yesterday I was doing an analysis of the SQL errorlog in response to a cluster node that had been crashing frequently. First I noticed there's a rather annoying bug in SQL Server Management Studio: if you press the filter button before all the log Read More... Posted Thursday, October 25, 2007 9:56 AM by BertrandR | 0 Comments Filed under: SQL 2005, SQL 2000, Errorlog