The dbcc_operation_log table records the use of the dbcc checkstorage operations.
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:
|
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.
Combination of dbid, opid, and optype