These procedures access the tables only in the dbccdb database or in the alternate database, dbccalt. See the System Administration Guide for details on setting up dbccdb or dbccalt. See Chapter 13, “dbccdb Tables,” in the Reference Manual Volume 4, Tables for information on the tables used in these databases.

Table 11-1 lists the dbcc stored procedures described in this chapter. For details on the dbcc system procedure sp_plan_dbccdb, see sp_plan_dbccdb. See the System Administration Guide for more information on this system procedure and the dbcc stored procedures.

Table 11-1: dbcc stored procedures

Procedure name



Changes the size of the specified workspace to a specified value, and initializes the workspace.


Generates a report that describes the configuration information used by the dbcc checkstorage operation for the specified database.


Creates a workspace of the specified type and size on the specified segment and database.


Deletes from dbccdb all the information related to the specified target database.


Deletes the results of dbcc checkstorage operations performed on the target database before the specified date and time.


Generates a report that highlights the changes in I/O statistics and faults that took place between two dbcc operations


Recomputes configuration information for the target database and compares it to the current configuration information.


Generates a report covering fault statistics for the dbcc checkstorage operations performed for the specified object in the target database on the specified date.


Runs sp_dbcc_summaryreport, sp_dbcc_configreport, sp_dbcc_statisticsreport, and sp_dbcc_faultreport.


Runs dbcc checkstorage on the specified database, then runs sp_dbcc_summaryreport or a report you specify.


Generates an allocation statistics report on the specified object in the target database.


Generates a summary report on the specified database.


Updates the dbcc_config table in dbccdb with the configuration information of the target database.