TSQL to get list of operations in active transaction of the current session
SQL Server has a wealth of Dynamic Management Views (DMVs) to get you health status of the platform.
All the data will be extracted with a query, set of transactions and many more ways, in this case you had to be careful with transactions, because whenever so much data was flowing back and forth between the application server and the database
server, too many things could go wrong. Here is the quick DMV that can get you list of operations in active transaction of the current session
declare @xactid bigint
declare @transactionid nvarchar(28)
select @xactid = transaction_id from sys.dm_tran_current_transaction
select @transactionid = [transaction id] from fn_dblog(null,null) where [Xact ID] = @xactid
select * from fn_dblog(null,null) where [Transaction ID] = @transactionid
The [Xact ID] introduced in SQL Server 2008 has the transaction id for the operation LOP_BEGIN_XACT and all the transaction occuring in its context share the common transaction with the [transaction id] column
