sp_dbcc_summaryreport reports all dbcc checkstorage operations that were completed for the specified database on or before the specified date. The following example shows output from this command:
sp_dbcc_summaryreport
DBCC Operation : checkstorage Database Name Start time End Time Operation ID Hard Faults Soft Faults Text Columns Abort Count User Name ------------------ -------------------- ---------- ------------ ----------- ----------- ------------ ----------- ------------------------------ sybsystemprocs 05/12/1997 10:54:45 10:54:53 1 0 0 0 0 sa sybsystemprocs 05/12/1997 11:14:10 11:14:19 2 0 0 0 0 sa
For details, see Chapter 10, “dbcc Stored Procedures,” in the Reference Manual.