How find out number of active SQL Server connections?
SELECT DB_NAME ( dbid ) as DBName , COUNT ( dbid ) as NumberOfConnections , loginame as LoginName FROM sys . sysprocesses WHERE dbid > 0 GROUP BY dbid , loginame ;