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 |
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) may contain a null value. At least one is 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
