dbcc_counters  dbcc_fault_params

Chapter 2: dbccdb Tables

dbcc_exclusions

Description

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.


Columns

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:

  • 1 – faults

  • 2 – tables

  • 3 – combo

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.


Primary key

Combination of dbid, fault_type, and table_name





Copyright © 2005. Sybase Inc. All rights reserved. dbcc_fault_params

View this book as PDF