dbcc_fault_params

Description

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


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.

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.


Primary key

Combination of dbid, opid, faultid, and type_code