可以通過下面代碼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 @spid
END
CLOSE CUR
DEALLOCATE CUR
? 版權聲明
文章版權歸作者所有，未經允許請勿轉載。
THE END
