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

0 votes

1 answer

196 views

audit extended-events change-data-capture

                          How do you correlate SQL Database Audit log column "transaction_id" with a LSN either from the trans log or a CDC capture table? 
I am trying to do this because cdc only captures the data changes, while SQL Audit captures the who, when and what made the change. I am trying to correlate the two.
thx
~j

                        

Asked by Joe Papp (1 rep)

Nov 30, 2023, 01:02 AM
Last activity: Jun 30, 2025, 10:02 PM

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

Related Questions