SQL SERVER 2008 删除某个数据库的所有连接进程

SQL SERVER 2008 删除某个数据库的所有连接进程

declare @spid int ;
declare @ddlstring nvarchar(max);
declare @dbname varchar(200);
set @dbname='BIDB';
declare tmpcur cursor 
for select distinct spid as spid from sys.sysprocesses
where dbid=db_id(@dbname) ;

OPEN tmpcur;
fetch tmpcur into @spid ;
while (@@FETCH_STATUS=0)
 begin 
   set @ddlstring=N'Kill '+CONVERT( nvarchar,@spid) ;
   execute sp_executesql @ddlstring ;
   fetch tmpcur into @spid ;
 end ;

close tmpcur ;
deallocate tmpcur ;

posted on 2014-04-11 20:02 bloodyboy 阅读( ...) 评论( ...) 编辑 收藏

转载于:https://www.cnblogs.com/bloodyboy/p/3659403.html