sp_listsuspect

Lists all databases that currently have offline pages because of corruption detected on recovery, including the database name, number of suspect pages, and number of objects containing suspect pages.

Syntax

sp_listsuspect_db

Examples

Example 1 – Lists the databases that have suspect pages:
```
sp_listsuspect_db
```

Usage

To identify suspect pages, use sp_listsuspect_page

Permissions

Any user can execute sp_listsuspect_db. Permission checks do not differ based on the granular permissions settings.

Auditing

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

Information	Values
Event	38
Audit option	exec_procedure
Command or access audited	Execution of a procedure
Information in `extrainfo`	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