1 Reply Latest reply on Oct 20, 2016 11:00 AM by m60freeman

    SQL Handle for a SQL Hash

    ryanjlind

      I have a Query in SQL Server instance that is truncated due to length. I really need to get this full query.

       

      I was hoping I could query the Ignite Database to find the link between the Hash in DPA (like 3013602881) to the sql_handle in sql server.  This way I'd be able to get the actual query.

       

      Can someone provide a query for this? I've been poking around tables in the Ignite database for 2 hours and haven't found this link anywhere.  I really need to know what this query is.  It is unacceptable that DPA truncates it due to length leaving me in the dark.