Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesIs 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
Post Follow-up to this messageHi 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
Post Follow-up to this messageIf 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
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread