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.
The permission checks for sp_dbcc_help_fault differ based on your granular permissions settings.
Granular permissions enabled |
With granular permissions enabled, you must be the database owner of dbccdb (or dbccalt). |
Granular permissions disabled |
With granular permissions disabled, any user can run sp_dbcc_help_fault. |
