SQL Server 終止交易(Transaction)

查詢交易(Transaction)：

    
SELECT active_transactions.transaction_id
     , session_transactions.session_id
     , exec_sessions.host_name
     , exec_sessions.login_name
     , exec_sessions.program_name
     , exec_sessions.client_interface_name
     , active_transactions.transaction_begin_time
FROM sys.dm_tran_active_transactions active_transactions
         JOIN sys.dm_tran_session_transactions session_transactions ON active_transactions.transaction_id = session_transactions.transaction_id
         JOIN sys.dm_exec_sessions exec_sessions ON session_transactions.session_id = exec_sessions.session_id;
    

範例查詢結果：

    
+--------------+----------+---------+----------+------------+--------------------------+-----------------------+
|transaction_id|session_id|host_name|login_name|program_name|client_interface_name     |transaction_begin_time |
+--------------+----------+---------+----------+------------+--------------------------+-----------------------+
|49453754      |51        |Ruyut    |ly_odi    |DataGrip    |Microsoft JDBC Driver 12.8|2025-01-17 00:03:07.080|
+--------------+----------+---------+----------+------------+--------------------------+-----------------------+
    

終止指定 session_id 的交易(Transaction)：

    
KILL 51;
    

延伸閱讀： SQL Server 交易 TRANSACTION

參考資料：
Microsoft.Learn - Transactions (Transact-SQL)