In SQL 2005, I would advise to use the DMV's sys.dm_exec_connections and sys.dm_exec_requests. The first will give you all user connections, while the second will show only the active connections.
Here you can find a good article about how to use them.
[font="Verdana"]Markus Bohse[/font]