Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 633
  • Last Modified:

Data Change Tracking In an Application

We  build applications with Access front ends and SQL 2000 backends. One of the requests we get frequently is to track when data is changed and who changed it.  Currently to do that we put code behind EVERY field to get the old value compare it to the new value and then if it is different put the information in a record log table. We then create a form so Management can search and view the changes.   I am sure there has to be a better and easier way!

I know SQL has a transaction log but is that something I can link into an application to display changes in a particular DB? Does anyone have any ideas? it will take me about a week to do it the way we have been so far. . Here is what our log end up looking like now

recordLog
Log_Seq      LogID      LogDate      FieldName      Was      Is      SubSeq      MainSeq      FormName
48394      Amelia Power      05/16/2007      Received      0      -1      10371      6302      BackGround Check Information
0
PSIUnit
Asked:
PSIUnit
1 Solution
 
Eugene ZCommented:
I would recommend 3rd party tools (www.idera.com)
but
you can try to use audit triggers:
http://sqlserver2000.databases.aspfaq.com/how-do-i-audit-changes-to-sql-server-data.html
--
Generic audit trail trigger
Author Nigel Rivett
http://www.nigelrivett.net/AuditTrailTrigger.html
0
 
twoboatsCommented:
Ditto.

The tran logs won't help you - without a 3rd party tool to read them.

You could enable c2 auditing, but it uses lots of space, and the info of who changed what isn't available to queries.
0
 
PSIUnitAuthor Commented:
I will research these and get back.. a third party software sounds great if i can swing the funding..

Thanks
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now