How to kill or rollback active transaction?

Viewed 53863

How can I kill or rollback, uncommitted transaction?

I am listing my active transactions with the following sql:

SELECT * FROM sys.dm_tran_session_transactions 

My result is:

session_id  transaction_id       transaction_descriptor enlist_count is_user_transaction is_local is_enlisted is_bound
----------------------------------------------------------------------------------------------------------------------
54          117260               0x0100000036000000     0            1                   1        0           0

I dont want to kill the session (54)...

Thanks all

2 Answers
Related