强制断开SQLServer数据库已有连接

如果数据库分离时，未选择切断所有连接可以使以下方式断开已有连接。

declare @i int declare cur cursor for select spid 
from sysprocesses where db_name(dbid)= 'Your_Database_Name' open cur fetch next 
from cur into @i while @@fetch_status=0 begin exec('kill '+@i) fetch next 
from cur into @i end close cur deallocate cur