Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Track changes on data
Message
 
 
To
06/04/2011 10:58:18
General information
Forum:
Microsoft SQL Server
Category:
Database management
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01506265
Message ID:
01506268
Views:
76
This message has been marked as the solution to the initial question of the thread.
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform