Provides a description of the specified fault type and the recommended fix.
sp_dbcc_help_fault [fault_type]
is the fault type for which a description and recommended fix should be reported. This parameter is type int. If fault_type is not provided, sp_dbcc_help_fault reports on all fault types.
To view a description of fault type 100038, and its recommended fix, enter:
sp_dbcc_help_fault 100038
To view a description of all fault types and their recommended fixes, enter:
sp_dbcc_help_fault
sp_dbcc_help_fault provides a description of the specified fault type and the recommended fix.
Any user can run sp_dbcc_help_fault.