Collections:
SINGLE_USER/MULTI_USER - Database User Access Options in SQL Server
How to set database to be SINGLE_USER in SQL Server?
✍: FYIcenter.com
Databases in SQL Server have three user access options:
You can use the "ALTER DATABASE" to change database user access options as shown in the tutorial below:
USE FyiCenterComData GO ALTER DATABASE FyiCentercomData SET SINGLE_USER GO
Now connect to server with another client session and try:
USE FyiCenterComData GO Msg 924, Level 14, State 1, Line 1 Database 'FyiCenterComData' is already open and can only have one user at a time.
Go back to the first session and re-set the database to MULTI_USER:
ALTER DATABASE FyiCenterComData SET MULTI_USER GO
⇒ System Databases Used by SQL Servers in SQL Server
⇐ READ_ONLY/READ_WRITE - Database Update Options in SQL Server
2016-11-20, 1089👍, 0💬
Popular Posts:
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...