Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - Database in Use When Dropping a Database

By: FYIcenter.com

(Continued from previous topic...)

Why I am getting this error when dropping a database?

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

(Continued on next topic...)

1. What is a database?
2. What is the simplest way to create a new database?
3. How to set the current database?
4. How to delete a database?
5. Why I am getting this error when dropping a database?
6. How to get a list all databases on the SQL server?
7. Where is my database stored on the hard disk?
8. How to create database with physical files specified?
9. How to rename databases?
10. Why I am getting this error when renaming a database?
11. What are database states?
12. How to set a database state to OFFLINE?
13. How to move database physical files?
14. How to set database to be READ_ONLY?
15. How to set database to be SINGLE_USER?
16. What are system databases?