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… READ MORE