Querying Database Connections in Express Edition

• Jeremy Saunders

  SSC Rookie

  Points: 26

  More actions

  May 3, 2006 at 5:36 am

  #169252

  Hi,

  This may sound amateurish, so I apologise for that upfront.

  I want to be able to query the number of sessions/connection/processes that are connected to a database on an SQL 2005 Express Edition instance.

  In SQL 2000 Enterprise Manager, this information can easily be view, but I don't know how to get to it via a script.

  I've been researching for hours, but cannot find a command to use to get me this info.

  I would appreciate a push in the right direction.

  Cheers,

  Jeremy.

   

• DanKennedy

  Hall of Fame

  Points: 3736

  More actions

  May 4, 2006 at 12:53 am

  #635846

  You should find this link helpful.

  http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=179&rl=1

  ---

  Dan
  www.firstcs.co.uk

• Jeremy Saunders

  SSC Rookie

  Points: 26

  More actions

  May 9, 2006 at 8:35 am

  #636765

  Thank you

  Cheers,

  Jeremy.