How to read transaction log of SQL Server database?

Hi,

Nice Information.

Pl note we have one more Un-Documended function :

Fn_DBLog

SELECT * FROM Fn_DBLog(StartLSN, EndLSN)

The two parameters are optional, So that we can give as NULL. It will read the all log info of the current Database.

We can use the range StartLSN, EndLSN. But the LSN will be in Hexadecimal format of data. We have to concert it into Integer and then we can use.

Cheers