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	Specifies the integer value.
realvalue	real	Specifies the real value.
binaryvalue	varbinary(255)	Specifies the binary value.
stringvalue	varchar(255)	Specifies the string value.
datevalue	datetime	Specifies the date value.

Each “value” column (intvalue, realvalue, binaryvalue, stringvalue, and datevalue) can contain a null value. At least one must not be 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