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
RickYou 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
No comments:
Post a Comment