Get query from cursor

• rVadim

  Hall of Fame

  Points: 3969

  More actions

  June 11, 2019 at 9:37 pm

  #3652510

  Something like this:

  SELECT
         c.session_id
        ,es.program_name
        ,es.login_name
        ,es.host_name
        ,c.properties
        ,c.creation_time
        ,c.is_open
        ,t.text
    FROM sys.dm_exec_cursors(0) c
      LEFT JOIN sys.dm_exec_sessions AS es
        ON c.session_id = es.session_id
      CROSS APPLY sys.dm_exec_sql_text(c.sql_handle) t;

  Source: https://community.dynamics.com/ax/f/33/t/194602

  --Vadim R.