query multiple database with login...

• Vincy-856784

  Ten Centuries

  Points: 1298

  More actions

  April 20, 2011 at 10:57 am

  #238811

  Hello all,

  I have multiple databases on the same server but i need to find the user count on each database on a regular interval.

  How can i achieve this using the sys.databases?

  Thanks,

  Vincent

• SQLRNNR

  SSC Guru

  Points: 281344

  More actions

  April 20, 2011 at 11:23 am

  #1314128

  This should get you what you need.

  select DB_NAME(database_id) as DBName, COUNT(database_id) as NumConnections

  From sys.dm_exec_requests

  Group by DB_NAME(database_id)

  Jason...AKA CirqueDeSQLeil
  _______________________________________________
  I have given a name to my pain...MCM SQL Server, MVP
  SQL RNNR
  Posting Performance Based Questions - Gail Shaw[/url]
  Learn Extended Events