SELECT request.session_id, request.status, request.blocking_session_id, request.wait_type, 
       userSessions.login_name, userSessions.host_name, userSessions.program_name,
	   sqlText.text 
FROM sys.dm_exec_requests as request
CROSS APPLY sys.dm_exec_sql_text(request.sql_handle) as sqlText
CROSS APPLY sys.dm_exec_sessions as userSessions