T-SQL Script: to get current connections to specific database

SELECT
    s.session_id,
    s.login_name,
    s.host_name,
    s.program_name,
    s.status,
    DB_NAME(txt.dbid) AS database_name,
    s.last_request_start_time,
    s.last_request_end_time
FROM sys.dm_exec_sessions s
JOIN sys.dm_exec_connections c
    ON s.session_id = c.session_id
CROSS APPLY sys.dm_exec_sql_text(c.most_recent_sql_handle) AS txt
WHERE txt.dbid = DB_ID('YourDatabaseName')
ORDER BY s.session_id;