dbcc tablealloc requires that you specify the table name, the data partition ID, or the table’s object ID from the ID column in sysobjects.
All pages are correctly allocated.
Partition statistics on the allocation pages are correct.
Every page that is allocated is used
Only allocated pages are used
All pages are correctly allocated to the partitions in the specified table.
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 specify one of the report options (full, optimized, fast, or null).