由於 4個 system database 的 id <= 4, 所以僅需取出 id > 4 的, 程式如下,
代碼: 選擇全部
declare @spid int, @dbid int, @cmd nvarchar(200)
declare c_processes cursor for
select spid, dbid from sysprocesses where dbid >4
open c_processes
fetch next from c_processes into @spid, @dbid
while @@fetch_status=0
begin
--print @spid
set @cmd = 'kill '+convert(nvarchar, @spid)
--print @cmd
exec sp_executesql @cmd
fetch next from c_processes into @spid, @dbid
end
close c_processes
deallocate c_processes