List of all open connections on SQL 2005 SERVER

SELECT *
FROM sys.dm_exec_connections