Wht deleted the rows

[Kieran Kelly]

Hi, I have a table and noticed that rows got deleted from it. I created a BEFORE DELETE trigger and logged the reuslts into another table. It happened in September and again at the end of January this year. The timing doesn't coincide with any of the scripts that I have running and I've quickly checked logs to see what was actually at the itme and can find nothing.

I have two questions.

1. Is it possible to find out exactly what was running at the time that might have caused this?

2. Is it possible to track or record the name of the process or script even the SQL statement that did the deletion, so that if it happens again, I might have more info?

Only some rows were deleted (quite a few, but not all)

Thanks in advance.

Kieran