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.

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

See also dbcc in Reference Manual: Commands.

Permissions

The permission checks for sp_dbcc_fullreport differ based on your granular permissions settings.

Setting	Description
Enabled	With granular permissions enabled, you must be the database owner of `dbccdb` (or `dbccalt`), or have the `report checkstorage` privilege on the specified database.
Disabled	With granular permissions disabled, any valid user for the database name specified can run sp_dbcc_fullreport.