dbcc_fault_params

The dbcc_fault_params table provides additional descriptive information for a fault entered in the dbcc_faults table.

Each “value” column (intvalue, realvalue, binaryvalue, stringvalue, and datevalue) can contain a null value. At least one must be not null. If more than one of these columns contains a value other than null, the columns provide different representations of the same value.

The primary key is the combination of dbid, opid, faultid, and type_code

Columns

The columns for dbcc_fault_params are:

Column name

Datatype

Description

dbid

smallint

Identifies the target database.

opid

smallint

Identifies the dbcc operation that was performed.

faultid

int

Identifies the fault ID.

type_code

int

Defines the interpretation of the value, which is provided by the “value” columns. Valid values are 1000 – 1009. They are described in dbcc_types.

intvalue

int null

Specifies the integer value.

realvalue

real null

Specifies the real value.

binaryvalue

varbinary(255) null

Specifies the binary value.

stringvalue

varchar(255) null

Specifies the string value.

datevalue

datetime null

Specifies the date value.

Related reference
dbcc_types