SELECT CAST(COUNT(1) AS VARCHAR)+ ' Transaction(s) in active' 'Transaction(s)' FROM sys.dm_tran_session_transactions
Login to post response