Database in Use When Dropping a Database in SQL Server

Q

Why I am getting this error when dropping a database in SQL Server?

✍: FYIcenter.com

A

If you are trying to drop a database that is in use, you will get an error message like this: 'Cannot drop database "FyiCenterData" because it is currently in use.'

Before dropping a database, you must stop all client sessions using this database. If your own client session is using this database, you should set a different database as the current database as shown in this tutorial example:

CREATE DATABASE FyiCenterData
GO

USE FyiCenterData
GO

DROP DATABASE FyiCenterData
GO
Msg 3702, Level 16, State 4, Server LOCALHOST\SQLEXPRESS
Cannot drop database "FyiCenterData" because it is 
   currently in use.

USE master
GO

DROP DATABASE FyiCenterData
GO

 

Managing Databases and Physical Files in SQL Server

⇒⇒SQL Server Database Tutorials

2016-11-24, 665👍, 0💬