无法删除数据库 "#Test",因为该数据库当前正在使用

ref：http://blog.csdn.net/wsh236/article/details/4296875

use master 
go 

declare @dbname sysname 
set @dbname='DB1' --这个是要删除的数据库库名 

declare @s nvarchar(1000) 
declare tb cursor local for 
select s='kill '+cast(spid as varchar) 
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+']')