Set database status on-the-fly

When you set the database state
With clause ignored, the ALTER database statement waits indefinitely when there are any locks in the database.
With no_wait, specifies that if a transaction has not yet been committed, it will fail immediately and no longer perform the following operation
With ROLLBACK after integer [SECONDS] | ROLLBACK IMMEDIATE: Specifies whether to roll back or rollback immediately after the specified number of seconds.

Note: Not all database options use the WITH <termination> clause, and not all database options can be specified with other options.

ALTER DATABASE adventureworks2012set single_userwith ROLLBACK IMMEDIATE; Goalter database adventureworks2012set read_onlygoalter database Adventureworks2012set multi_user; GO

Set database status on-the-fly