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 |
|
System procedures sp_listsuspect_page, sp_setsuspect_granularity, sp_setsuspect_threshold
