Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Cannot detach database 'xxx because it is currently using a workaround

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.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report