Use dbcc checkstorage to perform the following checks:
Allocation of text valued columns
Page allocation and consistency
OAM page entries
Pointer consistency
Text valued columns and text column chains
The syntax for dbcc checkstorage is:
dbcc checkstorage [(dbname)]
where dbname is the name of the target database (the database to be checked).
dbcc checkstorage runs checks against the database on disk. If a corruption is only in memory, dbcc checkstorage may not detect the corruption. To ensure consistency between two dbcc checkstorage runs, run checkpoint before running dbcc checkstorage. However, doing so can turn a transient memory corruption into corruption on disk.
