May 7, 2002 at 4:22 pm
There a history of all SQL table modifications? Looking for history of deletes, adds, etc...
May 8, 2002 at 6:06 am
Sorry but no. You have to build an audit process yourself for data changes, you can do this thru triggers. Physical structure changes are not tracked at all and have seen no noexternal apps for these just keep good scripts to compare.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Edited by - antares686 on 05/08/2002 06:07:08 AM
May 8, 2002 at 9:39 am
If you backup the log, it contains this information, but you need a tool like Log Explorer to get at it.
Steve Jones
May 8, 2002 at 10:01 am
Cool! Where do I get that neat little tool? (Log explorer)
May 8, 2002 at 10:06 am
quote:
Cool! Where do I get that neat little tool? (Log explorer)
There are free 30-day trial available on sites http://www.embarcadero.com/downloads/downloadlogexplorer.asp
or http://www.lumigent.com/capture.php
May be some more
May 8, 2002 at 10:47 am
THANK YOU! Got it.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply