All transactions/processes information query In MS SQL
set transaction isolation level read uncommitted SELECT [database] .*, [sp_who2] . spid , transaction_id , database_Transaction_Begin_Time , database_transaction_log_record_count , ( select top 1 text from sys . fn_get_sql ( sql_handle )) as sql_handle_firstquerytext , CASE database_transaction_state WHEN 1 THEN 'The transaction has not been initialized.' WHEN 3 THEN 'The transaction has been initialized but has not ...