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
Printable View
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 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.