To see which databases have offline pages, use sp_listsuspect_db. The syntax is:
sp_listsuspect_db
The following example displays general information about the suspect pages:
sp_listsuspect_db
The database 'dbt1' has 3 suspect pages belonging to 2 objects. (return status = 0)
To get detailed information about the individual offline pages, use sp_listsuspect_page. The syntax is:
sp_listsuspect_page [dbname]
If you don’t specify the dbname, the defaults is the current database. The following example shows the detailed page-level output of sp_listsuspect_page in the dbt1 database.
sp_listsuspect_page dbt1
DBName Pageid Object Index Access -------- ------------ --------- ------- ------------------- dbt1 384 tab1 0 BLOCK_ALL dbt1 390 tab1 0 BLOCK_ALL dbt1 416 tab1 1 SA_ONLY (3 rows affected, return status = 0)
If the value in the “Access” column is SA_ONLY, the suspect page is 1, the suspect page is accessible to users with the sa_role. If it is BLOCK_ALL, no one can access the page.
Any user can run sp_listsuspect_db and sp_listsuspect_page from any database.
