How many transaction(s) in active in the current Instance

PandianS
Posted by PandianS under Sql Server category on | Points: 40 | Views : 1720
SELECT CAST(COUNT(1) AS VARCHAR)+ ' Transaction(s) in active' 'Transaction(s)' FROM sys.dm_tran_session_transactions

Comments or Responses

Login to post response