CODE EXAMPLE FOR SQL

Cannot drop database because it is currently in use

USE MASTER;
GO

ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
DROP DATABASE dbname;
GO