title: Is there a way to list open transactions on SQL Server 2000 database?
body: <p>Does anyone know of any way to list open transactions on SQL Server 2000 database?</p>
  
  <p>I am aware that I can query the view <code>sys.dm_tran_session_transactions</code> on SQL 2005 (and later) database versions, however this is not available on SQL 2000.</p>