Finding a table in MSSQL like view V$session in Oraclegreenspun.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
-- Anonymous, November 21, 1999
sp_who will provide the loginame. This is obtained from the master..sysprocesses table.
Hope this helps,
-- Anonymous, November 24, 1999