data-konzept

'Have you ever wanted to be able to see the actual transactions that are contained in the transaction log file?  Well there is a way to read the transaction log file using an undocumented function.   In this article, I will show you how to browse the transaction log using this undocumented function.

To read the transaction log you I will be exploring using the undocumented function named “fn_dblog”.   This function requires two parameters to be passed.  The first parameter is the starting LSN (Log sequence number) and the second parameter is the ending LSN.   If you wanted to read all the data in the transaction log then you will need to pass null values for both of these parameters like so: 

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

http://www.databasejournal.com/features/mssql/how-to-read-the-transaction-log-file.html