Hi, maybe this can help:

SELECTdb_name(dbid) AS DB,

count(dbid) AS Connections,

loginame AS LoginName

FROMsys.sysprocesses

GROUP BY dbid, loginame

ORDER BY DB