September 24, 2002 at 7:22 am
Hello,
I have a little pb:
Rows are deleted from always the same table, and i don't know why !!
Is there a way to trace the deleted rows ??
Can i read the transcation journal ?
Thanks
September 24, 2002 at 7:30 am
Yes, you can run a trace using Profiler. It should be in your SQL Server application menu. If you can't find it, go to Start => Run and type Profiler and hit ok. Create a new trace. You can refine the results returned by playing with the filter tab.
Clive Strong
September 25, 2002 at 4:45 am
quote:
Is there a way to trace the deleted rows ??
As far as knowing what rows were deleted, no. But as for the command then as suggested before.
quote:
Can i read the transcation journal ?
Best way is with a third party app LogExplorer. Beyond that nothing that you can make sense with exists in SQL Server. Unless you are profiling during the delete.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply