sqlsql-serverldf

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


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?


Solution

  • 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: