Drop a Database by Closing Existing Connections using SSMS or T-SQL

 

Dropping database from SQL Server is not a major task. However, it can be painful if that database is being used at time of dropping it. Read this FAQ from www.sql-server-performance.com