Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL Server: How to decode rowlog content?

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.

like image 898
goodfella Avatar asked Oct 28 '25 08:10

goodfella


1 Answers

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.

like image 166
siggemannen Avatar answered Oct 31 '25 12:10

siggemannen