CODE EXAMPLE FOR SQL

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