The dbcc_operation_results table provides additional descriptive information for an operation recorded in the dbcc_operation_log table.
Each “value” column (intvalue, realvalue, binaryvalue, stringvalue, and datevalue) may 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.
Hard faults found
Soft faults found
Operations stopped due to a hard error
The primary key is the combination of dbid, opid, optype, and type_code
The columns for dbcc_operation_results are:
|
Column Name |
Datatype |
Description |
|---|---|---|
|
dbid |
smallint |
Identifies the target database. |
|
opid |
smallint |
Identifies the dbcc operation ID. |
|
optype |
smallint |
Identifies the dbcc operation type. |
|
type_code |
int |
Defines the dbcc operation type. Valid values are 1000 – 1007. 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. |
|
seq |
smallint null |
The sequence number for a checkverify operation. |