The dbcc_operation_results table provides additional descriptive information for an operation recorded in the dbcc_operation_log table.
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 Table 2-1. |
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. |
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.
Results of the dbcc checkstorage operations include the number of:
Hard faults found
Soft faults found
Operations stopped due to a hard error
Combination of dbid, opid, optype, and type_code
