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 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.
Combination of dbid, opid, and optype
