The dbcc_operation_log table records the use of the dbcc checkstorage operations.
Summary results are recorded in the dbcc_operation_results table.
The primary key is the combination of dbid, opid, and optype
The columns for dbcc_operation_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. |