Listing all connected users

• willian-1136841

  SSChasing Mays

  Points: 645

  More actions

  August 19, 2009 at 6:25 am

  #213573

  Is there a command (like a SELECT) to show all conected users?

  Example: SELECT LOGGED_USERS .....

  Result:

  sa

  user1

  administration

  etc.

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  August 19, 2009 at 6:51 am

  #1041464

  try using

  sp_who2

• DNA_DBA

  SSCrazy Eights

  Points: 9134

  More actions

  September 10, 2009 at 3:19 am

  #1051622

  select * from sys.dm_exec_sessions

• Apurva

  SSCrazy

  Points: 2412

  More actions

  September 11, 2009 at 9:21 am

  #1052372

  SELECT * FROM sys.dm_exec_connections

  SELECT * FROM sys.dm_exec_sessions

  SELECT * FROM sys.dm_exec_requests