SINGLE_USER/MULTI_USER - Database User Access Options in SQL Server
How to set database to be SINGLE_USER in SQL Server?
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
2016-11-20, 1274🔥, 0💬
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...