How to query the content of LDF file in SQL Server

New Contributor

How to query the content of LDF file in SQL Server though sql sentence

2 Replies

Hello,

 

There is no supported way to read the content of the log file (LDF), that's omething completley internal.

 

But there is the unsupported function fn_dbog:

 

SELECT COUNT(*) FROM fn_dblog(null,null)

 

thanks,guys.But is the result of this SQL query the whole content of the log?@olafhelper