Chapter 1: System Procedures

sp_listsuspect_db

Lists all databases that currently have offline pages because of corruption detected on recovery.

sp_listsuspect_db

Lists the databases that have suspect pages:

sp_listsuspect_db

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.

Values in event and extrainfo columns from the sysaudits table are:

Event	Audit option	Command or access audited	Information in extrainfo
38	exec_procedure	Execution of a procedure	Roles – Current active roles Keywords or options – NULL Previous value – NULL Current value – NULL Other information – All input parameters Proxy information – Original login name, if set proxy in effect