SQL Server - Connections Per Database

gistfile1.txt

--- Simple
SELECT
	@@SERVERNAME AS 'Server',
	DB_NAME(dbid) as 'Database',
	COUNT(dbid) as 'Number Of Open Connections'
FROM
	sys.sysprocesses
WHERE
	dbid > 0
GROUP BY
	dbid
with rollup
order by
	2

--- Detailed
SELECT
	@@SERVERNAME AS 'Server',
	sd.name DBName,
	sp.dbid,
    loginame [Login],
    hostname,
	[program_name] 'Program Name',
	[spid],
    last_batch LastBatch,
    blocked BlkBy,
	sp.[status],
	cmd Command,
    cpu CPUTime,
    physical_io DiskIO
FROM sysprocesses sp 
JOIN sysdatabases sd ON sp.dbid = sd.dbid
where sp.loginame<>'sa'
ORDER BY 2, 4