December 17, 2013 at 6:10 pm
Hi All,
I would like to ask you about the most recommended tool for tracking the process of Insert , update , or delete to a table and I will know which tables that has been changed in a database.
That tool should inform me about the person who modifies and the time it is modified .
I would appreciate for the response
Thank you!
Regards,
Mimi
December 17, 2013 at 11:59 pm
That tool is already built-in into SQL Server:
SQL Server Audit (Database Engine)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
December 18, 2013 at 5:00 am
You may also want to take a look at Extended Events within SQL Server. You can set them up to capture all the queries that are run against the system. It's a pretty standard method for gathering performance metrics, but it will work for auditing too. You can also capture data definition language statements that way.
"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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply