The syntax is:
dbcc checkverify(dbname[,tblname [,ignore_exclusions]])
Where dbname is the name of the database to check, tblname is the name of the table on which checkverify is to operate, and ignore_exclusions is either 0 the default (enables the exclusion list) or 1 (disable the exclusion list).
checkverify operates on the results of the last completed checkstorage operation for the specified database only.
When the checkverify operation is complete, Adaptive Server returns the following message:
DBCC checkverify for database name, sequence n completed at date time. n suspect conditions resolved as faults and n resolved as innocuous. n checks were aborted.
The following example runs checkverify on the table tab with exclusion list disabled, in the database my_db:
dbcc checkverify(my_db, tab)
To run dbcc checkverify on table tab, in database my_db, with the exclusion list enabled, enter:
dbcc checkverify (my_db, tab, 0)
To run dbcc checkverify on table tab, in database my_db, with the exclusion list disabled, enter:
dbcc checkverify (my_db, tab, 1)
You can run checkverify automatically after running checkstorage by using sp_dbcc_runcheck.
You can exclude tables, faults, and table or fault combinations from checkverify. Use sp_dbcc_exclusions to indicate which items you want excluded from checkverify. sp_dbcc_exclusions is dynamic; that is, checkverify immediately excludes the items you specify in sp_dbcc_exclusions. Once you exclude these objects from checkverify, it does not report on them the next time you run the command. .
You can disable the exclusion list support by entering a value of 1 for the checkverify parameter, ignore_exclusions.
