364,111 Members | 2078 Browsing Online
Community for Developers & IT Professionals
Bytes IT Community

sp_who

yacov klein
P: 1
when i run Sp_Who2 i can see only my self.
i would like to see all users which are logon to the server.
How can i to it?
I use SQL2008
Jan 22 '12 #1
Share this Question
Share on Google+
3 Replies


PsychoCoder
Expert Mod 100+
P: 208
You can try one or two different ways. First is

Expand|Select|Wrap|Line Numbers
  1. select hostname, program_name, loginame, cpu, physical_io,
  2. memusage, login_time, last_batch, status
  3. from master.dbo.sysprocesses
  4. where dbid = db_id('YourDBName')
  5. order by hostname
  6.  
Expand|Select|Wrap|Line Numbers
  1. Or simply using SP_WHO
Jan 29 '12 #2

shv214
P: 3
you can try this to get all active users

EXEC sp_who;
Apr 12 '12 #3

ck9663
Expert 2.5K+
P: 2,732
Here, try this...

Good Luck!!!


~~ CK
Apr 13 '12 #4

Post your reply

Help answer this question



Didn't find the answer to your Microsoft SQL Server question?

You can also browse similar questions: Microsoft SQL Server