select TOP 1 name from sys.dm_tran_active_transactions where name in ('implicit_transaction', 'topn_fake_worktable', 'sort_init') order by transaction_begin_time DESC
select TOP 1 name from sys.dm_tran_active_transactions where name in ('implicit_transaction', 'topn_fake_worktable', 'sort_init') order by transaction_begin_time DESC
Код: sql
1. 2. 3. 4. 5. 6.
begin tran
select * from sys.dm_tran_active_transactions a
join sys.dm_tran_session_transactions s
on s.transaction_id = a.transaction_id
and s.session_id = @@spid
commit tran
