dbcc tablealloc checks the specified user table to ensure that:
All pages are correctly allocated.
Partition statistics on the allocation pages are correct.
No page is allocated that is not used.
All pages are correctly allocated to the partitions in the specified table and that no page that is allocated is not used.
No page is used that is not allocated.
The syntax for dbcc tablealloc is:
dbcc tablealloc(table_name | table_id [, full | optimized | fast | NULL [, fix | nofix | NULL [, data_partition_name | data_partition_id ]]])
You can specify the table name, the data partition ID, or the table’s object ID from the ID column in sysobjects. If you specify a data partition ID, dbcc tablealloc performs its checks on this partition and all local index partitions. If you specify an object name or an object ID, dbcc tablealloc performs its checks on the entire table. If you specify an index partition ID, dbcc tablealloc returns error 15046.
To use the fix or nofix options for dbcc tablealloc, you must also specify one of the report options (full, optimized, fast, or null). For details on using the fix and no fix options, see “Correcting allocation errors using the fix | nofix option”. For details on the reports, see “Generating reports with dbcc tablealloc and dbcc indexalloc”.
