Lists all databases that currently have offline pages because of corruption detected on recovery.
Lists the databases that have suspect pages:
sp_listsuspect_db lists the database name, number of suspect pages, and number of objects containing suspect pages.
Use sp_listsuspect_page to identify the suspect pages.
Any user can execute sp_listsuspect_db.
System procedures sp_listsuspect_page, sp_setsuspect_granularity, sp_setsuspect_threshold