In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-07 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
The database is used most of the time, if in the process of use, we have to separate the database for some other operations. Then there will be an error like the one shown below.
So how to solve this problem? In general, when we operate in the SSMS view, we will close the connected users of SQL.
But how do you do it in command-line mode? The figure below is as follows
Execute the detach database command again and OK
Summary and usage
The fundamental reason why the database cannot be separated is that there is a user connection operation. First of all, we have to kill the process if we want to terminate the user connection.
Select spid from sysprocesses dbid=db_id ('eBay market')
Kill 56-- this is the query result of the above statement
Use master
Go
Exec sp_detach_db @ dbname='E_market'
Go
Separation succeeded
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.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.