Try to drop a SQL database, but get following errors:
USE Master; GO DROP DATABASE dbTEST; GO
Msg 3702, Level 16, State 4, Line 1 Cannot drop database "dbTEST" because it is currently in use.
Kill the blocking sessions, or set database in SINGER_USER mode with “Rollback Immediate” option to kill and rollback the transactions.
USE [master] GO ALTER DATABASE dbTEST SET SINGLE_USER WITH ROLLBACK IMMEDIATE; GO USE [master] GO DROP DATABASE dbTEST; GO
After this, check both data files and log files are cleaned up as well.