Stored procedures for generating reports on dbccdb

Table 5-8 lists the dbcc stored procedures for generating reports on dbccdb.

Table 5-8: Stored procedures for generating reports on dbccdb

Stored Procedure

Description

sp_dbcc_configreport

Reports the configuration parameters for the specified database.

sp_dbcc_differentialreport

Compares the results of dbcc checkstorage operations completed on date1 and date2 for dbname..object_name.

sp_dbcc_faultreport

Reports faults that were recorded for dbname..object_name on or before the specified date.

sp_dbcc_fullreport

Reports configuration, statistics, and fault information for database..object_name on or before the specified date.

sp_dbcc_statisticsreport

Reports statistics information from the dbcc_counters table generated by the dbcc checkstorage operation on or before the specified date.

sp_dbcc_summaryreport

Reports all dbcc checkstorage operations completed for dbname on or before the specified date.