代碼: 選擇全部
Declare @spid int
Declare @cmd nvarchar(200)
Declare proc_cursor cursor For
select spid from sysprocesses where hostname = 'some_host'
OPEN proc_cursor
FETCH NEXT FROM proc_cursor INTO @spid
WHILE @@FETCH_STATUS = 0
BEGIN
select @cmd = 'kill '+convert(nvarchar,@spid)
exec sp_executesql @cmd
FETCH NEXT FROM proc_cursor INTO @spid
END
CLOSE proc_cursor
DEALLOCATE proc_cursor