Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Titre:
SIMPLE long term transaction log
Versions des environnements
SQL Server:
SQL Server 2000
I need suggestions for permanent Data file change log in SQL 2000.
I would like to use a trigger on every table in a system to write a record to a data change log table for any data change. It is a Dot Net 1.1 web system using SQL 2000.
When any record is changed, I want to know the table name, the field, the before and after value. I will also store date/time and user ID from a session variable.
Obviously any given change could involve one field or dozens of fields in numerous tables.
I do not think the SQL transaction log will do that, but I am not sure.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement