Chapter 4: dbcc Stored Procedures

sp_dbcc_fullreport

Description

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.

Syntax

sp_dbcc_fullreport [dbname [, objectname [, date]]]

Parameters

dbname: specifies the name of the database. For example, master..sysdatabases. If you do not specify dbname, the report contains information on all databases in dbccdb..dbcc_operation_log.

object_name: specifies the name of the table or index for which you want the report generated. If you do not specify object_name, statistics on all objects in the target database are reported.

date: specifies the date on which the dbcc checkstorage operation was performed. If you do not specify a date, the date of the last operation is used.

Examples

Example 1

Runs sp_dbcc_summaryreport, sp_dbcc_configreport, sp_dbcc_statisticsreport, and sp_dbcc_faultreport short for the most recent dbcc checkstorage operation run on the sysprocedures table in the master database:

sp_dbcc_fullreport master, sysprocedures

Usage

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

Permissions

Any valid user for the database name specified can run sp_dbcc_fullreport.