How do you fix can't drop database because it is currently in use?

Question

For SQL server mgmt. studio: Right click database: Properties -> Options -> Restrict Access : Set to "Single User" and perform the drop afterwards. – .How to drop a database when it's currently in use? - Stack OverflowCannot drop a database in Azure Data Studio, because it's currently .Unable to drop database in SQL Server 2012 - Stack Overflow"Cannot drop database because it is currently in use". How to fix?Другие результаты с сайта stackoverflow.com

How do you solve Cannot drop database because it is currently in use?

I am getting Error as cannot drop database because it is currently in use.1Stop the SQL Server Service.2Delete the corresponding . mdf and . ldf files.3Start the SQL Server Service.4Connect with SSMS and delete the database.Cannot drop database because it is currently in use - Stack Overflow

Can not drop database that is currently in use?

To avoid this error, close all active connections to the database before the drop and terminate the current queries. Then close the tabs in SSMS or explicitly end the open connections on the database. Finally close the active tabs if only one user is currently connected.

How do I drop a database that is currently in use?

If you want to delete the database, you will get this error if there is an open session on the database. First, set the database to single_user mode. Then you can delete it.

Can not drop database because it is being used for replication?

Start by right-clicking Replication in Object Explorer, and choosing Publisher Properties: In the Publisher Properties window, select the Publication Databases page: Here you can deselect the database that you're trying to drop. Once you've saved this, you should be able to drop your database.

Expert · Answer