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_fullreport [dbname [, objectname [, date]]]
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.
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.
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.
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
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
The permission checks for sp_dbcc_fullreport differ based on your granular permissions settings.
Granular permissions 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. |
Granular permissions disabled |
With granular permissions disabled, any valid user for the database name specified can run sp_dbcc_fullreport. |
Commands dbcc
dbcc stored procedures sp_dbcc_statisticsreport, sp_dbcc_summaryreport, sp_dbcc_updateconfig
