All Connected User List Out Sql Server (Login User)

SELECT hostname 'Computer Name', DB_NAME(dbid) 'Database', program_name AS Program_Name, COUNT(program_name) 'TotalConnection'
FROM
       master.dbo.sysprocesses
WHERE
       hostname <> ''
       AND DB_NAME(dbid) <> 'master'
GROUP BY
       hostname, DB_NAME(dbid), Program_Name;