Ok, so more complex than tht
Still, the easiest way to see when checkDB last ran cleanly is to look at the dbi_dbccLastKnownGood, which tells you exactly that, when checkDB last ran without error
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability