users list

• srimkumarp-720356

  Ten Centuries

  Points: 1300

  More actions

  March 5, 2009 at 9:34 pm

  #201994

  Hi All,

  How can we find out how many users are connecting to the SQL database through applications.

  i am using sp_who2 but i want database wise.

  can any one please let me know how to find out query.

  thanks, kumar

• Renuka__

  Hall of Fame

  Points: 3656

  More actions

  March 5, 2009 at 10:11 pm

  #954638

  Hi,

  I think you can query SYSPROCESSES table; there is DBID returned and corresponding DB can be found from SYSDATABASES table.

  [font="Verdana"]Renuka__[/font]