无法删除 SQL Server 2012 中的数据库 [英] Unable to drop database in 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

这篇关于无法删除 SQL Server 2012 中的数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！