Re: Auditing changes to fields in SQL2000

From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 07/14/04 

Date: Wed, 14 Jul 2004 09:48:12 -0400

You can audit inserts, updates and deletes by adding the appropriate
triggers to the target tables, whereby the triggers write to audit tables.
You can capture the "before" image of each affected row. The after image
would be the current row in the audited table. 

-- 
    Tom
-------------------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON  Canada
www.pinnaclepublishing.com/sql
"Rick Bell" <rick@ramkey.com.au> wrote in message
news:uCvgRdaaEHA.2016@TK2MSFTNGP09.phx.gbl...
Is it possible to audit all changes to data within tables on SQL 2000? Not
concerned about auditing reads, only changes and deletions (a before/after
snapshot).
Wondering what performance impact should be expected, how to enable the
audit, and how to interpret the audit data?
Regards
Rick

Relevant Pages

  • Re: Viewing SQl transacion logs...
    ... However, as you can imagine, the overhead to maintain an audit ... we are converting to SQL server, if they were already keepijng those audit ... >> whether or not the change was part of a transaction? ... > triggers on any table to create an audit trail. ...
    (microsoft.public.sqlserver.odbc)
  • Re: Audit logging an adp
    ... connection, then you can pass in any username you like and it will remain local to the database connection. ... The triggers can read this data and store whatever value you pass in as the user ID. ... I sell a SQL Server audit product which automatically creates audit triggers for you, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Audit logging an adp
    ... Allen Browne's audit code. ... Some people may be tempted to suggest using SQL Server triggers, ... but without an adequate security model your audit trail ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Audit logging an adp
    ... if Access MDB had triggers; I would probably be using it right now lol. ... Allen Browne's audit code. ... Some people may be tempted to suggest using SQL Server triggers, ... but without an adequate security model your audit trail ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Results of Altering Trigger NOT FOR REPLICATION
    ... audit tables and they are therefore being kept in synch that way. ... altered the triggers so that they are NOT FOR REPLICATION. ... > the trigger to NFR and replicate both tables. ...
    (microsoft.public.sqlserver.replication)