Last DBCC checkdb date

Is there a way to find out when was DBCC checkdb run on a database in SQL
2000 and SQL 2005
Thanks,
Ranga
The last successful CHECKDB is found in the errorlog on 2005. SQL Server reports this at startup as
a type of "Last known Good".
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ranga" <Ranga@.discussions.microsoft.com> wrote in message
news:2D08F154-B9D1-4D76-982E-51B175A9C57A@.microsoft.com...
> Is there a way to find out when was DBCC checkdb run on a database in SQL
> 2000 and SQL 2005
> Thanks,
> Ranga
|||Hello,
All the DBCC CHECKDB executions will be having an entry in SQL Server error
log. AFAIK, there is no system views/catalogues stores this information.
Thanks
Hari
"Ranga" <Ranga@.discussions.microsoft.com> wrote in message
news:2D08F154-B9D1-4D76-982E-51B175A9C57A@.microsoft.com...
> Is there a way to find out when was DBCC checkdb run on a database in SQL
> 2000 and SQL 2005
> Thanks,
> Ranga