RATE THIS ANSWER
0
Click to Vote:
0
0
Use the Default template. Turn off all the defaults except the SQL:BatchComplete and turn on the SP:StmtCompleted
This will capture all the stored procedures and regular SQL, as well as all the commands within the stored procedures which are being executed. After the data loss has happened again stop the trace and use the find feature of SQL Profiler to look for DELETE commands.
Last Answered:
Sep 30 2008 7:28 PM GMT by Mrdenny 
47070 pts.