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, 631👍, 0💬
How To Create a Stored Function in Oracle? A stored function is a function with a specified name and...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...