Get Number of connections active per each DataBase

SELECT 
    DB_NAME(dbid) as DataBase_Name, 
    COUNT(dbid) as Number_Of_Connections,
    loginame as Login_Name
FROM
    sys.sysprocesses
WHERE 
    dbid > 0
GROUP BY 
    dbid, loginame