Data History

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a client that would like to be able to see a history of all changes
made to a given record over time and who made them. Is the transaction log
of any use for this? Do I need to craft something custom or is there a third
party app that does this? My initial searches have been fruitless. The app
uses an Access 2k .adp connected to SQL 2000.
 
Hi Dan,
you can use either tool which analize SQL Server log (there are few products
to do so you can find on internet, ApexSQL for example)
or create triggers to log changes to some table, this can take more time
from you, but you can get better results

--
Best regards,
___________
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com
 
I agree w/Alex that a trigger is probably your best option. I have this set
up for select fields in several of our tables and it works very well.

Jim
 
Back
Top