Display active session in SQL Server 2005

Question

In Oracle, there's a view called V$SESSION that lists all active sessions in database. Is there any similar view in SQL Server 2005?

Answer 1

See this answer.

Answer 2

select * from sys.sysprocesses

can be used instead of v$session in oracle

http://silverlightedworld.blogspot.com/2009/04/vsession-for-oracle-and-sql-server.html

Regards Renju www.renjucool.co.nr

Answer 3

Plain old sp_who.