sp_dbcc_help

Provides a description of the specified fault type and the recommended fix.

Syntax

sp_dbcc_help_fault [fault_type]

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.

Example 1 – To view a description of fault type 100038, and its recommended fix, enter:
```
sp_dbcc_help_fault 100038
```
Example 2 – 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.

Setting	Description
Enabled	With granular permissions enabled, you must be the database owner of `dbccdb` (or `dbccalt`).
Disabled	With granular permissions disabled, any user can run sp_dbcc_help_fault.