title: How do you find open transactions on Windows Azure SQL Database?
body: <p>In SQL Server 2008 R2 you can use the following to find all open transactions when debugging deadlocks:</p>
  
  <pre><code>DBCC OPENTRAN 
  </code></pre>
  
  <p>However that functionality is not available in Windows Azure SQL Database; it instead throws the errors:</p>
  
  <pre><code>"DBCC command 'OPENTRAN' is not supported in this version of SQL Server."
  </code></pre>
  
  <p>The <code>sp_who2</code> stored procedure doesn't exist either.</p>
  
  <p>What is the correct query for getting all open transactions within the Azure version of SQL Server?</p>