Who is connected to my SQL Server database?

-- Who is connected to my SQL Server database?

-- (SQL Server 2005 and later)

select s.session_id, s.login_time, s.host_name, s.program_name, s.login_name

from sys.dm_exec_sessions s

inner joinsys.dm_exec_requests r onr.session_id =s.session_id

where r.database_id = db_id()