Shulou(Shulou.com)05/31 Report--

Editor to share with you how Mssql server switches from single user to multi-user. I hope you will get something after reading this article. Let's discuss it together.

1. Execute alter database qysdb2014 set multi_user; to show that there is an existing connection on the database

2.select s.spid from sys.sysprocessselect * from master.sys.sysprocesses s where s.dbid in (select dbid from master.sys.sysdatabases m)

Where M. nameplates qysdb2014')

Here name is the name of the database you want to switch.

The spid queried above by 3.kill

4. Successful execution of alter database qysdb2014 set multi_user; modification

After reading this article, I believe you have a certain understanding of "how Mssql server switches single-user to multi-user". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.