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 sp_dbcc_summaryreport output:
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
See Reference Manual: Procedures > dbcc Stored Procedures.