Finding a table in MSSQL like view V$session in Oracle

greenspun.com : LUSENET : SQL Server Database Administration : One Thread
I want to find table or a view in MSSQL 6.5 like the one in Oracle (V$SESSION) which provide users information which are connected to the server like logID

thanks

-- Anonymous, November 21, 1999

Answers

Ali,

sp_who will provide the loginame. This is obtained from the master..sysprocesses table.

Hope this helps,

Eric

-- Anonymous, November 24, 1999

Moderation questions? read the FAQ