复制代码 代码如下:

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