Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Change Audit Log
Message
 
 
À
10/12/2007 23:11:25
Joel Hokanson
Services Integration Group
Bellaire, Texas, États-Unis
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01274691
Message ID:
01274851
Vues:
8
>I have a new VFP 9 application using SQL 2005 database. Naturally we backup the SQL often, but I would like to know if there are any utility programs that will keep an audit long for all changes?
>
>Frequently the company will ask who changed that record and when. Or who changed it from X to Y (and that may be several changes ago).
>
>I just want an change audit log for ALL tables.
>
>THANKS
>Joel in Houston

Hi Joel,

I just also found and tried this script http://vyaskn.tripod.com/tracking_sql_statements_by_triggers.htm

May be it can be helpful as well.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform