Chapter 4: dbcc Stored Procedures

sp_dbcc_runcheck

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

sp_dbcc_runcheck dbname [, user_proc]

dbname: specifies the name of the database on which the check is to be performed.

user_proc: specifies the name of the dbcc stored procedure or a user-created stored procedure that is to be run instead of sp_dbcc_summaryreport.

Checks the database engdb and generates a summary report on the information found:

sp_dbcc_runcheck "engdb"

Checks the database pubs2 and generates a full report:

sp_dbcc_runcheck "pubs2", sp_dbcc_fullreport

sp_dbcc_runcheck runs dbcc checkstorage on the specified database.
After the dbcc checkstorage operation is complete, sp_dbcc_runcheck runs sp_dbcc_summaryreport to generate a summary report. If you specify one of the other report-generating dbcc stored procedures for dbcc_report, sp_dbcc_runcheck runs that procedure instead of sp_dbcc_summaryreport. See the System Administration Guide for a brief description and examples of all the report-generating stored procedures provided with dbccdb.
You can write your own report-generating stored procedure and specify its name for user_proc. The stored procedure must be self-contained. sp_dbcc_runcheck cannot pass any parameters to Adaptive Server.

Only a System Administrator or the Database Owner can run sp_dbcc_runcheck.