[font="Courier New"]In SQL 2005 you can make use catalog views or DMV's for the same. You will get more information compared to sp_who2.. Users need view server state permission. Refer the below link.

Database Management Views & Functions - SQL 2005

[/font]