Get the SQL statement (inside a Stored Procedure) that is currently executed

  1. 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

 

Leave a Reply

Your email address will not be published. Required fields are marked *