Fixing – Msg 3702, Level 16, State 3 – Cannot Drop Database “DB_Name” Because it is Currently in Use

Geschrieben von Database Magician am Freitag, 1. April 2016

'Msg 3702, Level 16, State 3, Line 1
Cannot drop database “DemoDB” because it is currently in use.

The meaning of the error message is pretty clear that someone is using the database and it can’t be deleted/dropped. First, make sure that it is not our own connection. To make sure, always change the context before dropping the database as shown'...

http://blog.sqlauthority.com/2015/06/05/sql-server-fix-msg-3702-level-16-state-3-cannot-drop-database-db_name-because-it-is-currently-in-use/