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

Identifies when the operation ended

Summary results are recorded in the dbcc_operation_results table.


Primary key

Combination of dbid, opid, and optype