How to kill or rollback active transaction?

Question

Hi all,

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

You can't kill/rollback a transaction from another session without killing the owner session.

I think, allowing to kill/rollback a transaction from another user's session means many design and security rule violations because it requires entering another user session (in the context of the current sql server engine design). That's probably why it is not implemented.