dbcc checkstorage

Use dbcc checkstorage to perform the following checks:

The syntax for dbcc checkstorage is:

dbcc checkstorage [(dbname)]

where dbname is the name of the target database (the database to be checked).