log all changes in database

hi

I want to find the best way to log all changes in my database. for example who changes which field and when it has been done.

what are the solutions to handle this issue.

thanks

September 14th, 2015 11:28pm

To achieve this, you first will need to enable tracking, to get in detailed you have to look on this informative article which describes how to enable and disable change tracking for a database and a table.

To get automatic email alerts on who, where, what and when made the undesired changes in SQL server within the entire network, then you'll take help from this automated solution which servers you all your tracking, monitoring and reporting requirements with ease.

You may also take help from this earlier discussed thread having suggested solutions by experts to get this job done.

Hope it helps you!

Free Windows Admin Tool Kit Click here and download it now
September 15th, 2015 1:01am

you can use auditing triggers option to track all the security and transaction events of your database. 
September 15th, 2015 1:22am

Change tracking doesn't tell use who did the modification, unfortunately.
Free Windows Admin Tool Kit Click here and download it now
September 15th, 2015 3:16am

... and *possibly* Server Audit - but that has to be tested whether it satisfies the requirements (depending on whether the SQL comes in as parameterized SQL and if that is OK then).
September 15th, 2015 3:17am