Run dbcc
checkalloc, which checks page allocation.
To fix allocation errors, select Fix allocation errors. Adaptive Server automatically
places the database in single-user mode while executing dbcc checkalloc and
then returns the database to multiuser mode when processing
is complete.
The generated report shows the amount of space allocated and used by
each database table, including the system tables. For each table or index, the report shows the number of pages and
extents (8-page blocks of allocated space) used.
|