通过数据库脚本删除有未关闭连接的数据库

USE [master]
GO

ALTER DATABASE [DBName] SET  SINGLE_USER WITH ROLLBACK IMMEDIATE
IF  EXISTS (SELECT name FROM sys.databases WHERE name = N'DBName')
 DROP DATABASE [TMSData.201203131212]
GO