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?
Asked
Active
Viewed 552 times
2
-
Having SQL profiler attached or a trace enabled may be an easier way to see what is happening on your server. I dont think you can get to the internals of MSSQL data files, or be able to understand them if you could. – StingyJack Aug 27 '15 at 17:43
-
Profiler is great for right now, but I'm looking to view past entries. You may be right about not being able to view it, but this is why I'm asking if anyone knows how and can provide a solid example. – Benj Sanders Aug 27 '15 at 17:45
1 Answers
2
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:
Rahul Tripathi
- 168,305
- 31
- 280
- 331
-
-
-
1Slight modification: Select top 10 * from ::fn_dblog(null,null) Order By [Begin Time] DESC – Benj Sanders Aug 27 '15 at 17:59