问题描述
我之前创建了一个示例数据库,现在我想删除该数据库,但它没有被删除.我在网上搜索,但没有找到任何有效的解决方案.
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