The dbcc_exclusions table stores the faults, tables or a combination of them that should be excluded from processing by checkverify and fault reporting via sp_dbcc_faultreport.
The columns for dbcc_exclusionss are:
Column name |
Datatype |
Description |
|---|---|---|
dbid |
smallint |
Identifies the target database. |
type |
tinyint |
Exclusion type code. The valid values are:
|
fault_type |
int null |
The fault type to be excluded when type is 1 (faults) or 3 (combo). See “dbcc types” for more information. |
table_name |
varchar(30) null |
The table name to be excluded when type is 2 (faults) or 3 (combo). See “dbcc types” for more information. |
Combination of dbid, fault_type, and table_name
