Tag Archives: Upgrade

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

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 Upgrades ahoy!

A major problem facing many of us is that of sprawl.  In my case, I have databases served by SQL Server 2000, 2005 & 2008.  As if that’s not bad enough, the service pack levels on these servers varies, as … Continue reading

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