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.
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]])
You can specify either the table name or the table’s object ID from the id column in sysobjects.
If you want 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”.
