Lists all pages in a database that are currently offline because of corruption detected on recovery.
sp_listsuspect_page [dbname]
is the name of the database.
Lists the suspect pages in the current database:
sp_listsuspect_page
Lists the suspect pages in the pubs2 database:
sp_listsuspect_page pubs2
sp_listsuspect_page lists the database name, page ID, object, index ID, and access status for every suspect page in the specified database or, if dbname is omitted, in the current user database.
A value of SA_ONLY in the “access” column indicates that the page has been forced online for System Administrator use only. A value of BLOCK_ALL indicates that the page is offline for everyone.
Any user can execute sp_listsuspect_page.
System procedures sp_listsuspect_db, sp_setsuspect_granularity, sp_setsuspect_threshold
