dbcc_operation_results

Description

The dbcc_operation_results table provides additional descriptive information for an operation recorded in the dbcc_operation_log table.


Columns

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:


Primary key

Combination of dbid, opid, optype, and type_code