ITPro Today logo
SQL ServerThe Unkillable DBCC CHECKDBThe Unkillable DBCC CHECKDB
In the past I’ve noticed some very strange behavior when running ad-hoc consistency checks. If I interrupt DBCC CHECKDB, it sometimes hangs and the SPID says it’s rolling back, but DBCC CHECKDB doesn’t change anything. What’s going on?
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.