SELECT
r.session_id,
r.status,
r.command,
r.percent_complete,
r.wait_type,
r.wait_time,
r.wait_resource,
t.text AS sql_text
FROM sys.dm_exec_requests r
CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) t
WHERE r.database_id = DB_ID(‘YourDBName’);