Take the 2-minute tour ×  When I try to drop a database I get
the error "Cannot drop database "dbname" because it is currently
in use". However, when I run sp_who2, there are definitely no
sessions connected to this database. I've also set the database
to single_user mode with rollback immediate.  Why is this
happening?  share|improve this question Or try to ALTER the
database at Single_USER –  user1592 Apr 27 '11 at 11:31 Did you
change to master before setting the database to single_user mode
with rollback immediate ? –  bernd_k Apr 27 '11 at 11:34 As I
pointed out, I have already done this. –  tuseau Apr 27 '11 at
12:25 well we once did the alter database single_user immediate
from the database we wanted to drop. Very bad idea –  bernd_k
Apr 27 '11 at 13:19 Yeah thanks anyway :) –  tuseau Apr 27 '11
at 14:56 show 4 more comments  7 Answers  up vote 8 down vote
accepted  Make sure you don't have dependencies like database
snapshots on the db you want to remove. Though, the error
message would look otherwise