Indicates whether a database is in quiesce database mode. is_quiesced returns 1 if the database is quiesced and 0 if it is not.
is_quiesced(dbid)
is the database ID of the database.
Uses the test database, which has a database ID of 4, and which is not quiesced:
1> select is_quiesced(4) 2> go
----------- 0 (1 row affected)
Uses the test database after running quiesce database to suspend activity:
1> quiesce database tst hold test 2> go 1> select is_quiesced(4) 2> go
----------- 1 (1 row affected)
Uses the test database after resuming activity using quiesce database:
1> quiesce database tst release 2> go 1> select is_quiesced(4) 2> go
----------- 0 (1 row affected)
Executes a select statement with is_quiesced using an invalid database ID:
1>select is_quiesced(-5) 2> go
----------- NULL (1 row affected)
is_quiesced has no default values. You see an error if you execute is_quiesced without specifying a database.
is_quiesced returns NULL if you specify a database ID that does not exist.
ANSI SQL – Compliance level: Transact-SQL extension.
Any user can execute is_quiesced.
Command quiesce database
