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