dbcc Stored Procedures

dbcc stored 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 dbccdb Tables in Reference Manual: Tables for information on the tables used in these databases.

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.

The permission checks for dbcc stored procedures differ based on your granular permissions settings. See the Security Administration Guide for more information on granular permissions.

Specifying the Object Name and Date
Several dbcc stored procedures use parameters for the object name and date. This section provides important information on specifying the object name and date.
sp_dbcc_alterws
Changes the size of the specified workspace to a specified value, and initializes the workspace.
sp_dbcc_configreport
Generates a report that describes the configuration information used by the dbcc checkstorage operation for the specified database.
sp_dbcc_createws
Creates a workspace of the specified type and size on the specified segment and database.
sp_dbcc_deletedb
Deletes from dbccdb all the information related to the specified target database.
sp_dbcc_deletehistory
Deletes the results of dbcc checkstorage operations performed on the target database before the specified date and time.
sp_dbcc_differentialreport
Generates a report that highlights the changes in I/O statistics and faults that took place between two dbcc operations.
sp_dbcc_evaluatedb
Recomputes configuration information for the target database and compares it to the current configuration information.
sp_dbcc_exclusions
Allows the user to create and manage persistent exclusion lists for use by checkverify and sp_dbcc_faultreport.
sp_dbcc_faultreport
Generates a report covering fault statistics for the dbcc checkstorage operations performed for the specified object in the target database on the specified date.The report lists the tables and indexes in order.
sp_dbcc_fullreport
Runs sp_dbcc_summaryreport, sp_dbcc_configreport, sp_dbcc_statisticsreport, and sp_dbcc_faultreport short for database..object_name on or before the specified date.
sp_dbcc_help_fault
Provides a description of the specified fault type and the recommended fix.
sp_dbcc_patch_finishtime
Facilitates reporting on aborted checkverify and checkstorage operations.
sp_dbcc_recommendations
Analyzes faults reported by the checkstorage operation corresponding to the specified operation ID, or date, and generates a list of recommended corrective actions for the specified object in the target database.
sp_dbcc_runcheck
Runs dbcc checkstorage on the specified database, then runs sp_dbcc_summaryreport or a report you specify.
sp_dbcc_statisticsreport
Generates an allocation statistics report on the specified object in the target database.
sp_dbcc_summaryreport
Generates a summary report on the specified database.
sp_dbcc_updateconfig
Updates the dbcc_config table in dbccdb with the configuration information of the target database.