- Step: Find out the Session_ID of your Query: See integer number in parantheses in Query Window.
SELECT SUBSTRING(detail.text, requests.statement_start_offset / 2, (requests.statement_end_offset - requests.statement_start_offset) / 2) FROM sys.dm_exec_requests requests CROSS APPLY sys.dm_exec_sql_text (requests.plan_handle) detail WHERE requests.session_id = 67