dbcc textalloc

dbcc textalloc checks the allocation integrity of an object’s text and image data, and reports and fixes any problems it finds.

dbcc textalloc checks the specified object—or all objects that have text or image data in the current database—to ensure that:

Text and image entries in the system tables are correct.
OAM page chain and allocation of OAM pages for text and image data are correct.
All text and image pages are correctly allocated.
No text page is allocated but not used.
No text page is used but not allocated.

You can issue dbcc textalloc without any parameters. By default, dbcc textalloc runs in default mode. If you do not specify a parameter, dbcc textalloc checks each table in the current database that has a text or image column.

You can run dbcc textalloc concurrently on different objects without interfering with each other.