Options

How to Crack the Sql Text from Redgate Tables?

Nick1611Nick1611 Posts: 3 New member
in SQL Monitor 6
The sql text in the Redgate tables appears to be encrypted or in binary form; does anyone know how to crack the sql text (i.e. return it in human-readable form) from any of the QueryText or SqlText columns, such as:

   data.Cluster_SqlServer_TopQueries_Instances_View.Cluster_SqlServer_TopQueries_QueryText    or
   data.Cluster_SqlServer_SqlText_Instances.[_SqlText]   or
   data.Cluster_SqlServer_TopQueries_Instances.[_QueryText]

Naturally I have tried several CONVERTs and DECOMPRESSing, but nothing seems to work.

· Share on Twitter

Answers

  • Options
    Nick1611Nick1611 Posts: 3 New member
    Ah, just remembered that sql server ALSO encodes sqltext; the solution is to use the same sys dynamic function that you would use to get the sqltext from sql server's own repository namely: sys.dm_exec_sql_text
    · Share on Twitter
  • Options
    Nick1611Nick1611 Posts: 3 New member
    I've been looking at this again; the data sizes for the sql text strongly indicate that the sql text has been compressed, has anyone come across a way to decompress the data?
    · Share on Twitter
  • Options
    ssh4478ssh4478 Posts: 8 Bronze 1
    @Nick1611 Did you manage to get the human readable text ? I have got exactly the same dilemma ?
    Thanks
    · Share on Twitter
Sign In or Register to comment.