Find Currently Running Queries

SELECT [SQL_Text].TEXT , [Executing_Requests].session_id , [Executing_Requests].status , [Executing_Requests].command , [Executing_Requests].cpu_time , [Executing_Requests].total_elapsed_time FROM sys.dm_exec_requests AS [Executing_Requests] CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS [SQL_Text]