트랜잭션이 걸려있는지 확인

SELECT st.session_id, DATEDIFF(minute, last_request_end_time, getdate()), text, last_read, last_write, GETDATE(), *

FROM sys.dm_tran_session_transactions st

    INNER JOIN sys.dm_exec_sessions es

        ON es.session_id = st.session_id

    INNER JOIN sys.dm_exec_connections ec

        ON ec.session_id = es.session_id

    CROSS APPLY sys.dm_exec_sql_text(ec.most_recent_sql_handle)

WHERE st.session_id = @@SPID

BEGIN TRAN 걸고 도망간 넘 찾기

SELECT st.session_id, DATEDIFF(minute, last_request_end_time, getdate()), text, last_read, last_write, GETDATE(), *

FROM sys.dm_tran_session_transactions st

    INNER JOIN sys.dm_exec_sessions es

        ON es.session_id = st.session_id

    INNER JOIN sys.dm_exec_connections ec

        ON ec.session_id = es.session_id

    CROSS APPLY sys.dm_exec_sql_text(ec.most_recent_sql_handle)

WHERE DATEDIFF(minute, last_request_end_time, getdate()) > 1 -- 1분..

-- SQL2000

select 'kill ' + convert(char(4),spid)
from sys.sysprocesses
where open_tran >0 and  DATEDIFF(ss, last_batch, getdate()) > 3600
AND    spid > 50
AND    sql_handle <> 0x0

http://www.sqler.com/?mid=bColumn&page=5&document_srl=127222