How do I list all of the connections or view the total connections in use on SQL Server 2008

The answer is in this little script

SELECT DB_NAME(dbid) as 'Database Name',
COUNT(dbid) as 'Total Connections'
FROM sys.sysprocesses WITH (nolock)
WHERE dbid > 0
GROUP BY dbid

Thanks for http://www.sqldba.org/.../18-view-database-connections-in-sql-server.aspx

Its a life saver

< Prev		Next >