Sql Server : Set a database in Multi User Mode
- Posted by Sqltimes
- On December 5, 2015
- 0 Comments
Quick one today:
A while ago, we had a post on how to set a database in Single User mode to perform some operations. Now, we could look at how to set a database back to multi user mode.
1
2
3
4
5
6
|
-- -- Set a database in multi user -- ALTER DATABASE DBADB SET MULTI_USER GO |
It is simple and runs quickly.
Hope this helps,
_Sqltimes
0 Comments