Unknown's avatar

Cannot drop database because it is currently in use

This is a common scenario and there are lots of posts on this. The following works for me:

My database is  located on a virtual machine running Server 2012 and SQL Server 2012 under Hyper-V locally on my development machine.

In SQL Server Management Studio In the  object explorer pane right click the database and select “Detach” from the context menu. Check “Drop” in the resulting dialog:

Drop SQL Connections

Leave a comment