Tag Archives: DBCC

DBCC DBINFO() – Don’t rely on undocumented commands

Posted on July 28, 2019 by thomasrushton

Don’t Rely on Undocumented Commands – A Cautionary Tale Looking at the output for the (undocumented) DBCC DBINFO() command, I noticed a typo in one of the field names. I wondered about submitting it as a bug, but then looked … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , | 3 Comments

Possible SQL Server Trace Flag Gotcha

Posted on October 31, 2015 by thomasrushton

I was trying to turn on Traceflag 3226 in order to suppress the swarm of successful transaction log backup messages that floods the SQL Server (Error) Logs (& Windows Application logs). After all, if you’ve got more than a few … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , | 1 Comment

Querying SQL Server Event Logs to search for DBCC CheckDB output

Posted on September 12, 2012 by thomasrushton

This is a long-winded response to a query raised on AskSSC, about how to report on the running of DBCC. One way suggested was to use Ola Hallengren’s scripts to schedule and report. However, I have another way that I … Continue reading →

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

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