Drop in use SQL Server database

ALTER DATABASE name SET single_user WITH ROLLBACK immediate;
DROP DATABASE name;