Tag Archives: SQL Server 2000

Adventures with DBCC and Database Upgrades

Posted on November 1, 2011 by thomasrushton

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

Displaying varbinary in SSRS?

Posted on March 22, 2011 by thomasrushton

I was recently writing a report in SSRS that required me to display a SID – a nasty little piece of data normally represented as a varbinary(85), and that looks like an enormous hex number. I wrote my query in … Continue reading →

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