数据库连接被占用时,使用下面SQL可以强制关闭连接:
declare @spid int;
declare @ddlstring nvarchar(max);
declare @dbname varchar(200);
set @dbname='dbname'
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_STAUS=0)
begin
set @ddlstring=N'KILL '+CONVERT(NVARCHAR,@spid);
execute sp_executesql @ddlstring;
fetch tmpcur into @spid;
end;
close tmpcur;
deallocate tmpcur;