dbcc tablealloc

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.

dbcc tablealloc checks the specified user table to ensure that:

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).