New answers tagged audit
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 ...
Top 50 recent answers are included
Related Tags
audit × 406sql-server × 190
oracle × 84
mysql × 42
trigger × 38
security × 28
sql-server-2012 × 26
oracle-11g-r2 × 24
sql-server-2008-r2 × 20
oracle-12c × 19
postgresql × 17
database-design × 15
sql-server-2008 × 15
sql-server-2016 × 14
logins × 14
sql-server-2014 × 13
azure-sql-database × 10
permissions × 8
sql-server-2005 × 8
users × 8
oracle-11g × 7
delete × 7
extended-events × 7
change-data-capture × 7
sql-server-2019 × 6