-
Who has deleted records
Dear Sir,
how can i find out as who has deleted particular records from a table.
i am using SQL2000 SP4
pls. explain a little bit in detail
regards
-
You need third party sql auditing tools or run profiler trace all the time.
-
Thanks
Thanks rmiao...
can you name me any better third party tool?
-
Check Lumigent's Audit DB and Log Explorer.
-
You can't use it after the fact. Log explorer may show you that data got deleted but will not show where the connection came from.
-
It tells db user and windows id.
-
I don't think user information is in transaction log, so if you are running lumigent on old transaction log files when lumigent was not capturing login information you don't see that.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|