None

Do not perform consistency checking.

Full check, excluding indexes

Select this option to exclude indexes from the consistency check. If indexes are not checked, the consistency check runs significantly faster but is not as thorough. Only the data pages and clustered index pages for each user table are included in the consistency check. The consistency of the non-clustered index pages is not checked.

Full check, including indexes

Include indexes in the consistency check. Any errors are logged.

Physical check only (SQL 2000 only)

Select this option to perform a low overhead check of the physical consistency of the SQL Server 2000 database. This option only checks the integrity of the physical structure of the page headers and record headers. It also checks the consistency between the pages' object ID and index ID and the allocation structures.