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)

Example 1 – 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)
```

Example 2 – 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)

Example 3 – 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)

Example 4 – 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.
Returns NULL if you specify a database ID that does not exist.

See also quiesce database in Reference Manual: Commands.

ANSI SQL – Compliance level: Transact-SQL extension.

Any user can execute is_quiesced.