USE master
GO
DECLARE @dbname sysname
SET @dbname='TEST' --这个是要删除的数据库库名
DECLARE @s NVARCHAR(1000)
DECLARE tb CURSOR local FOR
SELECT s='KILL '+CAST(spid AS NVARCHAR)
FROM master..sysprocesses
WHERE dbid=DB_ID(@dbname)
OPEN tb
FETCH next FROM tb INTO @s
WHILE @@FETCH_STATUS=0
BEGIN
EXEC(@s)
FETCH next FROM tb INTO @s
END
CLOSE tb
DEALLOCATE tb
EXEC('DROP DATABASE ['+@dbname+']')