sp_listsuspect_db

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

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:

InformationValues
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

Related reference
sp_listsuspect_page
sp_setsuspect_granularity
sp_setsuspect_threshold