How can I decode the rowlog content 0, or content 1 which is obtained through fn_dblog() into a readable form? I mean for an update log I want to decode the updated value from content 1 and previous value from content 0.
This project looks quite promising for parsing the actual data: https://github.com/ap0405140/MSSQLLogAnalyzer
But as others mentioned, this information is not well documented and you need to use some arcane/unsupported methods to read the logs, ie. FN_DBLOG / FN_DUMP_DBLOG, so be careful while using this in production environment.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With