Table 5-7 lists the dbcc stored procedures for maintaining dbccdb.
Stored Procedure |
Description |
|---|---|
sp_dbcc_alterws |
Changes the size of the specified workspace to the specified value, and initializes the workspace. |
sp_dbcc_deletedb |
Deletes all information on the specified database from dbccdb. |
sp_dbcc_deletehistory |
Deletes results of dbcc checkstorage operations on the specified database from dbccdb. |
sp_dbcc_evaluatedb |
Recommends values for configuration parameters, using the results from previous dbcc operations. |
sp_dbcc_runcheck |
Runs dbcc checkstorage on the specified database and generates a summary report or the report you specify. |
