dbcc_operation_log  dbcc_types

Chapter 2: dbccdb Tables

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 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:


Primary key

Combination of dbid, opid, optype, and type_code





Copyright © 2005. Sybase Inc. All rights reserved. dbcc_types

View this book as PDF