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:

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.