SQL Server - View a specific log entry in transaction log file (ldf)

Question

This may have been asked before but I made a simple update to one column (varchar(max)) in a table and wanted to know if there is a simple way to look at the transaction log file (ldf) to see that specific update? Can you possibly provide specific examples?

Answer 1

I dont think you can do that ie, you can view a specific entry in your transaction log. The best I can think of is to use:

Select * from ::fn_dblog(null,null)

You can also check:

• How Do You Decode A Simple Entry in the Transaction Log?
• SQL Server fn_dblog() Function Details and Example