sp_dbcc_faultreport reports faults in the specified database object that occurred on or before the specified date. You can generate a short or long report. The following example shows a short report:
sp_dbcc_faultreport ’short’
Database Name : sybsystemprocs Table Name Index Type Code Description Page Number -------------- ------ --------- ------------------- ----------- sysprocedures 0 100031 page not allocated 5702 sysprocedures 1 100031 page not allocated 14151 syslogs 0 100022 chain start error 24315 syslogs 0 100031 page not allocated 24315
The following example shows part of the output of a long report for the sybsystemprocs database. The complete report repeats the information for each object in the target database.
sp_dbcc_faultreport 'long'
Generating 'Fault Report' for object sysprocedures in database sybsystemprocs. Type Code: 100031; Soft fault, possibly spurious Page reached by the chain is not allocated. page id: 14151 page header: 0x00003747000037880000374600000005000648B803EF0001000103FE0080000F Header for 14151, next 14216, previous 14150, id = 5:1 time stamp = 0x0001000648B8, next row = 1007, level = 0 free offset = 1022, minlen = 15, status = 128(0x0080)
