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.