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
Technology Tips and News
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
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!