Tag Archives: SQL Server 2000

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

Displaying varbinary in SSRS?

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 , , , | 1 Comment