고아 연결 찾아내고 KILL 시키기

USE master

GO

SELECT spid, open_tran, hostname, last_batch, login_time, * 

FROM sysprocesses 

WHERE spid > 50

AND open_tran > 0

AND last_batch < DATEADD(mi, -1, GETDATE())

GO

DBCC INPUTBUFFER(52)

GO

SELECT 'KILL ' + CONVERT(VARCHAR(30), spid)

FROM sysprocesses 

WHERE spid > 50

AND open_tran > 0

AND last_batch < DATEADD(mi, -1, GETDATE())

GO

sp_who2

SELECT * FROM sysprocesses