Chapter 2: Transact-SQL Functions

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.

is_quiesced(dbid)

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.