断开Sql Server 2005所有连接

断开Sql Server 2005所有连接

 

use   master 
go 

declare   @d   varchar(8000) 
set   @d= ' ' 
select   @d=@d+ '   kill   '+cast(spid   as   varchar)+char(13) 
from   master..sysprocesses   where   dbid=db_id( 'aspectdemo ') 
exec(@d)