The dbcc_fault_params table provides additional descriptive information for a fault entered in the dbcc_faults table.
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.
Combination of dbid, opid, faultid, and type_code
