Very helpful script. Thanks. I changed it a bit to make the code cleaner. This produces the same result:

USE MASTER

SELECT

s.session_id, s.host_name, s.program_name, s.client_interface_name, s.login_name

,s.nt_domain, s.nt_user_name, c.client_net_address, c.local_net_address

--,c.connection_id,c.parent_connection_id, c.most_recent_sql_handle

,(SELECT text FROM sys.dm_exec_sql_text(c.most_recent_sql_handle)) as sqlscript

,(SELECT db_name(dbid) FROM sys.dm_exec_sql_text(c.most_recent_sql_handle)) as databasename

,(SELECT object_id(objectid) FROM sys.dm_exec_sql_text(c.most_recent_sql_handle)) as objectname

FROM

sys.dm_exec_sessions as s

INNER JOIN

sys.dm_exec_connections as c

ON c.session_id = s.session_id