Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Track changes on data
Message
 
 
À
06/04/2011 10:58:18
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01506265
Message ID:
01506268
Vues:
77
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform