无法删除 SQL Server 2012 中的数据库
我之前创建了一个示例数据库，现在我想删除该数据库，但它没有被删除.我在网上搜索，但没有找到任何有效的解决方案.
I have created a sample database earlier and now I want to delete that database, but it is not getting deleted. I searched online but I didn't find any solution which is working.
使用 T-SQL，我尝试过:
Using T-SQL, I tried:
USE [Sample]
ALTER DATABASE [Sample]
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
GO
DROP DATABASE [Sample]
使用 GUI，我收到以下错误:
Using the GUI, I am getting this below error:
我关闭了现有的连接，然后这也发生了，这是我的本地机器.请在这里帮助我！
I closed existing connection then also this is happening and this is my local machine. Please help me here!
推荐答案
使用此代码:
USE MASTER
GO
ALTER DATABASE Sample
SET multi_user WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE Sample
SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
DROP DATABASE Sample
GO
相关文章