用管理员账户sa登陆，然后在master下新建查询：
在查询窗口输入：
declare @i int declare cur cursor for select spid from sysprocesses where db_name(dbid)= "要断开衔接的数据库名称" 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 declare @i i
