>Is there a T-SQL command I can use to close all connections to a database? I want to use the command before I DROP DATABASE MyDb.
>
>Thanks,
>Einar

There is a database setting that automatically closes unused tables. Check ALTER DATABASE command for all the possible settings.

Also I just found an answer by googling:


ALTER DATABASE databaseName
SET SINGLE_USER WITH ROLLBACK IMMEDIATE


or

http://www.experts-exchange.com/Database/Miscellaneous/Q_21314163.html?query=sql+server+force+connections+closed&clearTAFilter=true