dbcc_operation_log

Description

The dbcc_operation_log table records the use of the dbcc checkstorage operations.


Columns

The columns for dbcc_operaiton_log are:

Column Name

Datatype

Description

dbid

smallint

Identifies the target database.

opid

smallint

Identifies the sequence number of the dbcc checkstorage operation. opid is an automatically incrementing number, unique for each dbid and finish pair.

optype

smallint

The following value is valid for optype:

  • 2 = checkstorage

suid

int

Identifies the user executing the command.

start

datetime

Identifies when the operation started.

finish

datetime null

Identifies when the operation ended.

seq

smallint null

The sequence number for a checkverify operation.

id

int null

The object ID, if used, for a checkverify operation.

maxseq

smallint null

The maximum sequence used by checkverify for a checkstorage oepration.

Summary results are recorded in the dbcc_operation_results table.


Primary key

Combination of dbid, opid, and optype