GilaMonster (7/20/2012)
opc.three (7/20/2012)
If dbi_dbccFlags = 1 then it has never run clean.That just tells you whether data purity checks have ever been run and return clean, not if CheckDB has. If the DB was upgraded from 2000, it's possible for that to be 0 even with a clean checkDB having been completed a second earlier.
To see when CheckDB last ran without error, look at the dbi_dbccLastKnownGood which is the date that CheckDB last ran without error. If it's 1900..., the answer is Never.
See Paul's comment in the article I linked to. If it is taken out of context that's ok. When I lokked for docs on that flag when I first learned of this page I came up mostly empty. I imagine that's why the poster posed the question in the first place.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato