List of all transactions that are running in SQL Server’s instance

     SELECT sqltext.TEXT
     ,req.session_id
     ,req.status
     ,req.command
     ,req.cpu_time
     ,req.total_elapsed_time
     ,req.blocking_session_id
     ,req.percent_complete
     ,req.estimated_completion_time/1000/60  estimated_completion_time_Min
     ,start_time
    FROM sys.dm_exec_requests req
    CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext
    ORDER BY start_time