sqlserver下Kill 所有连接到某一数据库的连接
复制代码 代码如下: USE master DECLARE @spid int DECLARE CUR CURSOR FOR SELECT spid FROM sysprocesses WHERE dbid = 5 FETCH NEXT FROM CUR INTO @spid WHILE @@FETCH_STATUS = 0 BEGIN --EXEC ('KILL ' + @spid ) FETCH NEXT FROM CUR INTO @sp
复制代码 代码如下:USE masterDECLARE @spid intDECLARE CUR CURSORFOR SELECT spid FROM sysprocesses WHERE dbid = 5FETCH NEXT FROM CUR INTO @spidWHILE @@FETCH_STATUS = 0BEGIN--EXEC ('KILL ' + @spid )FETCH NEXT FROM CUR INTO @spidENDCLOSE CURDEALLOCATE CUR
