SQL Server : CRUD Editor that will track data changes I'm looking for a tool that allows CRUD changes to SQL Server data. Our company currently utilizes a product from Pro Data called DBU (database utility) to make IBM DB2 / AS400 changes. This tool tracks CRUD activity, including before and after data changes. Then it produces a log that can be reviewed for audit purposes.

I tried several tools that track object level changes on the server, including SQL Server built-in tracking, however this is not the desired affect. We would like to expose a utility to a group of users and track only that particular activity. 

Any suggestions or recommendations?
I won't use a own product for this.

You have two simple ways to do it on your own.


You can use CDC (Change-Data-Capture) which will do this automatically. You can retrieve the changes afterwards for some time. (If you don't need that every value is hold back for ever)
You can create an Before-Update trigger, which will generate a own log for a record before and after the insert. You can just query those log table and everything is fine. The end-user won't see anything of this, he can use Access, SSMS or whatever to achieve the changes.