August 2, 2004 at 10:21 am
Is there a way to view transaction logs to determine who deleted data in our production tables? We have some production tables that are missing data every 2 weeks and we are trying to pinpoint the user and the statement that deleted the data.
Thanks.
Rene
August 2, 2004 at 10:27 am
have a look at a product called LOG P.I.
this can disect logs - but a better method is to create some triggers on your tables that audit deletes into a logfile or table.
MVDBA
August 3, 2004 at 1:21 am
If that's something you DONT want someone to do, why not set some DENY DELETE permissions?
This wont work if a stored procedure is doing the delete, but its a starting point.
It should become fairly obvious when someone comes to tell you that the bad thing they are trying to do doesn't work.
But as Mike said, if you want to capture the event, but not prevent it, you could use a trigger.
Julian Kuiters
juliankuiters.id.au
August 4, 2004 at 8:28 am
This may help you but not that much. Try use LogPI or Entegra
dbcc log(mydatabase_name, 2)
August 4, 2004 at 11:02 pm
try lumigent log explorer.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply