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, 3215🔥, 0💬
Popular Posts:
How Many Groups of Data Types in MySQL? MySQL support 3 groups of data types as listed below: String...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
What Happens to the Current Transaction If a DDL Statement Is Executed in Oracle? If a DDL statement...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...