sp_who

[yacov klein]

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

[PsychoCoder]

You can try one or two different ways. First is

select hostname, program_name, loginame, cpu, physical_io,
memusage, login_time, last_batch, status
from master.dbo.sysprocesses
where dbid = db_id('YourDBName')
order by hostname

Or simply using SP_WHO

[shv214]

you can try this to get all active users

EXEC sp_who;

[ck9663]

Here, try this...

Good Luck!!!


~~ CK