fn_dblog( ) function documentation
Goal: This post provide some documentation for the fn_dblog() function. Key Points: * view transaction log of a database (if you want to view the transaction log of a log backup, use fn_dump_dblog function instead.) * useful for: > restore database to a certain point in time > find out when an operation (page split, table delete, table truncate...). * take 2 parameters, start time and end time. * It's not recommended use this function to scan the transaction log of a production database because it can reduce performance due to increase disk I/O. -- get fn_dblog() definition sp_helptext 'sys.fn_dblog'; --result create function sys.fn_dblog ( @start nvarchar (25) = NULL, @end nvarchar (25) = NULL ) returns table as return ...