| Author |
How to find how a record was deleted
|
|
| rdraider 2005-07-21, 8:24 pm |
| Is there a way to tell who or what process deleted a record in a SQL table.
I know you can setup triggers or Profiler - but is there a way to see how a
record was deleted if you DO NOT have a trigger or Profiler already running?
This is SQL 2000 Standard, sp3a with default options and configuration.
Thanks
| |
| jsfromynr 2005-07-22, 3:23 am |
| Hi rdraider,
It may help your cause
Step 1 : Login as sa or user with sa rights
Step 2 : Run a trace with minimum TSQL (Statement Start , Statement
Complete)
If you wish to know from where(EM or SQL Query Analyzer) record is
deleted then the column Applicationname of Trace output will help you.
With warm regards
Jatinder
| |
| Simon Hayes 2005-07-22, 3:23 am |
| If you have log backups, then there are several third-party tools which
can read them and recover information about when data was deleted. For
example:
http://www.lumigent.com/products/le_sql.html
Simon
|
|
|
|