title: Display active session in SQL Server 2005
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/216007/how-to-determine-total-number-of-open-active-connections-in-ms-sql-server-2005">How to determine total number of open/active connections in ms sql server 2005</a>  </p>
  </blockquote>
  
  
  
  <p>In Oracle, there's a view called V$SESSION that lists all active sessions in database. Is there any similar view in SQL Server 2005?</p>