-- currently running requests (queries)
SELECT r.session_id, s.TEXT, r.[status], r.blocking_session_id, r.cpu_time, r.total_elapsed_time
FROM sys.dm_exec_requests r
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS s

-- currently running cursors
SELECT ec.session_id, ec.name,ec.properties, ec.creation_time, ec.is_open, ec.writes,ec.reads,t.text
FROM sys.dm_exec_cursors (0) ec
CROSS APPLY sys.dm_exec_sql_text (ec.sql_handle) t

https://sqlperformance.com/2012/09/t-sql-queries/cursor-options