How to Crack the Sql Text from Redgate Tables?

Nick1611

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.

Nick1611

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

Nick1611

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?

ssh4478

@Nick1611 Did you manage to get the human readable text ? I have got exactly the same dilemma ?
Thanks