How to kill or rollback active transaction?

Question

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

Answer 1

To clear all transaction, Use this only as a temp solution

ALTER DATABASE DatabaseName

SET SINGLE_USER

WITH ROLLBACK IMMEDIATE;

ALTER DATABASE DatabaseName

SET MULTI_USER;

refer this site for more info

Points to check - it also rollbacks committed transactions