New answers tagged transaction-log
1
vote
Correlating SQL Audit transaction_id to LSN
is there a function, DMV or otherwise that can retrieve a Transaction ID when given a LSN - that does not require the sysadmin role to execute/query?
Why not run sys.fn_dblog() via a trigger on the ...
Top 50 recent answers are included
Related Tags
transaction-log × 790sql-server × 569
backup × 161
sql-server-2012 × 83
sql-server-2008-r2 × 60
sql-server-2014 × 58
sql-server-2008 × 49
restore × 47
sql-server-2016 × 45
availability-groups × 45
log-shipping × 37
shrink × 34
recovery × 29
mysql × 25
performance × 25
sql-server-2005 × 25
transaction × 24
postgresql × 22
mirroring × 22
oracle × 20
logs × 20
recovery-model × 20
replication × 18
innodb × 16
tempdb × 15