data-konzept

'Ever wondered how to read the transaction log for a database? There is an undocumented SQL function sys.fn_dblog which may help you to read T-Log except for the truncated transaction details. We can use this function effectively for point in time recovery at a LSN level.

First lets see how the typical output of the function, I have run the function on the AdventureWorks2012 DB,

SELECT * FROM sys.fn_dblog(NULL,NULL)'...

http://www.sqltechnet.com/2016/01/sysfndblog.html