In the mean while I am doing this because i am asked to check every night who made insert/update/delete to a certain table and check the old data (deleted and updated) or the new data (inserted)
Audit trigger writing into an audit table.
The transaction log is NOT for audit purposes, don't try to use it as such. Go with a trigger or, if this is actually a SQL 2008+ server, CDC, Change Tracking or SQL Audit, whichever meets your needs
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass