Currently executing queries SQL Server 2008 R2

currently_executing_queries.sql

SELECT
   sqltext.text
  ,req.session_id
  ,req.status
  ,req.command
  ,req.cpu_time
  ,req.total_elapsed_time
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext;