sp_dbcc_help_fault

Description

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

Syntax

sp_dbcc_help_fault [fault_type]

Parameters

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.

Examples

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

Usage

sp_dbcc_help_fault provides a description of the specified fault type and the recommended fix.

Permissions

Any user can run sp_dbcc_help_fault.