cannot drop database because it is in use code example
Example: cannot drop database because it is currently in use
Someone connected to the database. Try to switch to another database and then, to drop it:
Try
SP_WHO to see who connected
and KILL if needed