text: -- ALL OPEM TRANSACTIONS
  SELECT * FROM sys.sysprocesses WHERE open_tran = 1
  
  -- SUMMARY OF TRANSACTION
  SELECT
  trans.session_id AS [SESSION ID],
  ESes.host_name AS [HOST NAME],login_name AS [Login NAME],
  trans.transaction_id AS [TRANSACTION ID],
  tas.name AS [TRANSACTION NAME],tas.transaction_begin_time AS [TRAN BEGIN TIME],
  tds.database_id AS [DATABASE ID],DBs.name AS [DATABASE NAME]
  FROM sys.dm_tran_active_transactions tas
  JOIN sys.dm_tran_session_transactions trans
  ON (trans.transaction_id=tas.transaction_id)
  LEFT OUTER JOIN sys.dm_tran_database_transactions tds
  ON (tas.transaction_id = tds.transaction_id )
  LEFT OUTER JOIN sys.databases AS DBs
  ON tds.database_id = DBs.database_id
  LEFT OUTER JOIN sys.dm_exec_sessions AS ESes
  ON trans.session_id = ESes.session_id
  WHERE ESes.session_id IS NOT NULL
  
  -- LOCKS HELD
  
  SELECT resource_type,request_type,request_mode,request_status,resource_description FROM sys.dm_tran_locks where resource_type <> 'DATABASE'
  /*
   * IS = Intent Shared
   * IX = INTENT eXclusive
   * S = Shared 
   * X = eXclusive lock
   */
  
  SELECT cmd,* FROM sys.sysprocesses WHERE blocked > 0