Generates a report covering fault statistics for the dbcc checkstorage operations performed for the specified object in the target database on the specified date.The report lists the tables and indexes in order.


sp_dbcc_faultreport [report_type [, dbname [, objectname
	[, date [, hard_only [, exclusion_mode[, exclusion_faults
	[, exclusion_tables [, exclusion_combo 
	[, display_recommendations [, opid [,fault_type_in]]]]]]]]]]]]




There are additional considerations when using sp_dbcc_faultreport:
  • sp_dbcc_faultreport generates a report that shows all faults for the specified object in the target database.

  • sp_dbcc_faultreport issues numerous error message number 10028 If you use:
    • sp_placeobject to make an object that has existing allocations put new allocations on a new segment.

    • sp_dropsegment to remove a segment from a fragment that contains allocations of an object assigned to that segment.

      Error message number 100028 is an informational message rather than an indication of a serious error. If you prefer not to receive such messages, you can create your own reporting procedure that does not report this (or any other) error. One way to do this is to add the following to the very beginning of the standard sp_dbcc_faultreport stored procedure in the installdbccdb script:
      print "removing 100028 errors from dbcc_faults table"
      delete dbcc_faults where type_code = 100028
  • If sp_dbcc_faultreport returns a number for object_name, it means the object was dropped after the dbcc checkstorage operation completed.

See also:
  • dbcc in Reference Manual: Commands

  • type_code in the System Administration Guide for information on the fault ID and on the fault status.


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


With granular permissions enabled, you must be the database owner of dbccdb (or dbccalt), or have the report checkstorage privilege on the specified database.


With granular permissions disabled, any valid user for the database name specified can run sp_dbcc_faultreport.

Related reference