is_quiesced

Indicates whether a database is in quiesce database mode. is_quiesced returns 1 if the database is quiesced and 0 if it is not.

Syntax

is_quiesced(dbid)

Parameters

Examples

Usage

is_quiesced:
  • Has no default values. You see an error if you execute is_quiesced without specifying a database.

  • Returns NULL if you specify a database ID that does not exist.

See also quiesce database in Reference Manual: Commands.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute is_quiesced.