Single User Connection in MSSQL
Single Connection in MSSQL and bringing it back to Multi user connection
1. -- single user
2. ALTER DATABASE [db_name]
3. SET single_user
4. WITH ROLLBACK IMMEDIATE
5.
6.
7. -- multi user
8. ALTER DATABASE [db_name]
9. SET multi_user
Comments