master.sys.dm_exec_connections – has server-level information about the connections to SQL Server.
http://msdn.microsoft.com/en-us/library/ms181509(SQL.90).aspx – SQL Server 2005
http://msdn.microsoft.com/en-us/library/ms181509.aspx – SQL Server 2008