Current DB Connections

• mickeytech2000

  Mr or Mrs. 500

  Points: 556

  More actions

  March 31, 2007 at 6:38 pm

  #123267

  I am trying to count the number of current DB connections. sp_who gives infor on all dbs. How do I filter out  (count) the connections to a database?

  Thank you.

  Mickey

• MohammedU

  SSCoach

  Points: 19644

  More actions

  March 31, 2007 at 11:03 pm

  #697983

  select count(*) from sysprocesses where db_name(dbid)= '<dbname>'

   

  MohammedU
  Microsoft SQL Server MVP