New answers tagged

0 votes

How do you correlate SQL Database Audit spec's log column transaction_id with a LSN? from trans log or CDC capture table?

The best way that I've been able to find for this is probably by querying sys.fn_dblog, though it isn't officially documented or supported by Microsoft. There is a very thorough 3rd party blog post ...
Dyllon Gagnier's user avatar

Top 50 recent answers are included