>Good Day, I did my web application and i'm wondering if its not crazy to keep every change performed on data. The users accessing this app won't be more that 20, but i would like to know how is a master record today and how is it tomorrow. SQLserver has a tool to acomplish this?
>T.I.A.
If you're using SQL Server 2008, then you may want to look at Change Data Capture feature.
Check Kevin's articles referenced in this reply
Re: Trigger question Thread #
1500199 Message #
1500284(You may start from the first article I referenced and then go to Kevin's).
If it's not broken, fix it until it is.
My Blog