sp_dbcc_exclusions

Description

Allows the user to create and manage persistent exclusion lists for use by checkverify and sp_dbcc_faultreport.

Syntax

sp_dbcc_exclusions dbname, op, type, exclusion_list

Parameters

Examples

Example 1

Excludes the tables syslogs and syscomments from sp_dbcc_faultreport processing on all databases:

sp_dbcc_exclusions null, 'add', 'tables', 'syslogs,
    syscomments'

Example 2

Excludes fault type 100036 from processing of the database my_db:

sp_dbcc_exclusions my_db, 'add', 'faults', '100036'

Example 3

Adds the following to the exclusion list corresponding to my_db: fault type 100002 pertaining to table mytable and fault type 100035 pertaining to syslogs:

sp_dbcc_exclusions my_db, 'add', 'combo', ‘mytable:100002, syslogs:100035’

Example 4

Removes fault type 100036 from the exclusion list corresponding to my_db:

sp_dbcc_exclusions my_db, 'drop', 'faults', '100036'

Example 5

Displays the exclusion list corresponding to my_db:

sp_dbcc_exclusions my_db

Example 6

Displays the recorded exclusions for all databases:

sp_dbcc_exclusions null, 'listall'

Usage

• dbname must be null when listall is specified. If op is null, sp_dbcc_exclusions lists the recorded exclusions for the specified database.

• Only a System Administrator or the Database Owner can run sp_dbcc_exclusions with a dbname parameter that is not null.

• If the dbname and op parameters are null, the user must either be a System Administrator or own at least one of the databases for which exclusions have been recorded.

• If the dbname parameter is null and the op parameter is listall, the user must either be a System Administrator or own at least one of the databases for which exclusions have been recorded. If the user is not a System Administrator, only the recorded exclusions for databases owned by the user will be reported.

Permissions

The permission checks for sp_dbcc_exclusions differ based on your granular permissions settings.