470,866 Members | 1,903 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,866 developers. It's quick & easy.

Methoology for data changes being tracked

I need to be compliant with law that keeps a history of changes to tables as
records are edited. What is the best way to do this ? I was thinking a SQL
trigger on each table that writes to another change table on update (seems a
bit much), or use an OnChange event when ADO.NET posts to track the changes.
Is there a better approach to what seems a standard problem these days ?
Jun 2 '06 #1
1 1147
The only completely reliable way is to use the db triggers someone could
easily change the data in the db without going through your interface (or
someone could feasable modify your application to bypass the audit code).
That said, many people also use code level logging .. if are using something
like an object persistence framework (nhibernate etc) many have extension
points for things like logging. If youa re just using ADO and calling
inserts directly etc as opposed to a centralized framework I might lean
towards triggers as the code will get to be tough to maintain (as someone
could easily forget to put in an audit or miss an audit)

Cheers,

Greg Young
MVP - C#
http://geekswithblogs.net/gyoung
"Ronj" <Ro**@discussions.microsoft.com> wrote in message
news:B1**********************************@microsof t.com...
I need to be compliant with law that keeps a history of changes to tables
as
records are edited. What is the best way to do this ? I was thinking a SQL
trigger on each table that writes to another change table on update (seems
a
bit much), or use an OnChange event when ADO.NET posts to track the
changes.
Is there a better approach to what seems a standard problem these days ?

Jun 3 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Vikram | last post: by
reply views Thread by Redd | last post: by
1 post views Thread by Diane Yocom | last post: by
4 posts views Thread by Paul | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.