fix for 'Cannot drop database “MyDatabase” because it is currently in use' error

To fix the 'currently is in use error while dropping database, the below code snippet will work...

USE MASTER
GO
ALTER DATABASE MyDatabase
SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
DROP DATABASE MyDBName
GO

NOTE: Do NOT run this in Production environment.....