SELECT Substring(o.text, ( r.statement_start_offset / 2 ) + 1,
                 ( ( CASE r.statement_end_offset
                         WHEN -1 THEN Datalength(o.text)
                         ELSE r.statement_end_offset
                         END -
                     r.statement_start_offset ) / 2 ) + 1)          AS statement_text,
       o.text                                         AS text,
       Isnull(r.context_info, CONVERT(VARBINARY, '')) AS context_info
FROM   sys.dm_exec_requests r
           INNER JOIN sys.dm_exec_sessions s
                      ON r.session_id = s.session_id
           INNER JOIN sys.dm_exec_connections c
                      ON s.session_id = c.session_id
           CROSS apply sys.dm_exec_sql_text(r.plan_handle) AS o