强制断开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