Search code examples
sql-serverdbcc

tsql to know when dbcc checkdb was run on a database last time


Using Tsql, how can i know when DBCC checkdb was last run on SQL server (2000, 2005 or 2008)?

Regards


Solution

  • on 2005 and up you can run

    DBCC DBINFO ('YourDatabaseName') WITH TABLERESULTS
    

    look for dbi_dbccLastKnownGood