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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply