Activity overview
Latest activity by 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? / comments
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?
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 / comments
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_...
How to Crack the Sql Text from Redgate Tables?
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...