I am currently running a v2.1 database with 50+ users each of whome open a number of programs.

I have a problem in that a block of records on one table are being incorrectly deleted, but cannot similate or otherwise identify it. The records are automatically recreated by a program every few hours, but every time within a few hours the block is deleted again.

I have created an ondelete trigger on the database that identifies the records being deleted and that records the record id and time in a #monitor' table.

Is there a function/udf that I can use in the ondelete event that will give me information to track the user/program/computer/sql responsible?

Thanks in advance