View Single Post

   
  #2 (permalink)  
Old 02-29-2008, 08:30 AM
jsfromynr
 
Posts: n/a
Default Re: How to find how a record was deleted

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

Reply With Quote