Tag Archives: SQL Server 2005

Waitresource Key

I was watching a server this morning, making sure that there was nothing untoward going on, and I caught sight of a LCK_M_S waittype with a very long number in the Resource column: KEY: 26:72057594819903488 (6b0068a71fb9). I watched a bit … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , | Leave a comment

Adventures with DBCC and Database Upgrades

We have (had?) an application that has been retired (Hurrah!).  However, even though it has been retired, there is still the occasional request to extract data from this database, which was hosted on a SQL2000 SP3a server.  So what I’m … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , , , | 3 Comments

Lazy programming from MS? Surely not…

Another vignette from SQL Server 2005 Management Studio showing a possible lack of attention to detail somewhere… (Speaking of lack of attention to detail, I can’t remember which version of the SSMS had this bug.  I suspect it was RTM, … Continue reading

Posted in SQLServerPedia Syndication, Uncategorized | Tagged , , | Leave a comment

Unable to launch Activity Monitor.

It all started so innocently. A SQL Server 2005 installation.  An installation of SQL Workbench, sorry, “Microsoft SQL Server Management Studio.”  And a need to find out what’s going on.  Click, click, click – Activity Monitor.  Double-click.  Uh-oh. (Incidentally, why … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , , , | 2 Comments

SQL Server 2005 RTM Maintenance Cleanup FAIL

A recent question on AskSSC reminded me of a little issue affecting SQL Server 2005’s maintenance plans; specifically, the Maintenance Cleanup task. Those of you (un)lucky enough to still be running SQL 2005 RTM may well be aware of this, … Continue reading

Posted in SQLServerPedia Syndication, Uncategorized | Tagged , | Leave a comment

SQL Server 2005 SP3 Installation problem

I knew it was all going too smoothly… I’ve just been upgrading a few instances of SQL Server 2005 to SP3 (I know, I know…).  Things have been mostly going well, until I got to one server that threw up … Continue reading

Posted in SQLServerPedia Syndication, Uncategorized | Tagged , | Leave a comment