January 18, 2016 at 1:48 pm
Hi Guys,
What is the best approach to audit Insert/Update/Delete operations for a sql server table.
I've read about Triggers, CDC, Extended events...
Version: SQL 2014
Please share your thoughts.
Many thanks!
January 18, 2016 at 4:59 pm
The best way to audit is probably... surprise... an audit!
It's an enterprise only feature, so no joy if you're running on standard edition. In that case, the options you already have enumerated are possible solutions.
Here is a solution based on Extended Events: http://spaghettidba.com/2015/04/20/tracking-table-usage-and-identifying-unused-objects/
It's not exactly what you're after, but the technique can be adapted to track individual events.
Good luck!
-- Gianluca Sartori
January 19, 2016 at 1:34 am
ExEvents outside of enterprise really is the most flexible and powerful mechanism for auditing.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply