title: Get number of connected users in SQL Server 2000
body: <p>While I'm trying to detach a database through Enterprise Manager, it shows the no. of users accessing the database and it didn't allow us to detach without clearing the database connection.</p>
  
  <p>Well, I want to know whether the result (no. of users connecting a particular database) could be obtained through a SQL query?  If yes, how ?</p>
  
  <p>Happiness Always
  BKR Sivaprakash</p>