Hi,

looks really good, thanks!

so just to make sure, i need to replace TBL_TEST_AUDIT with my table and my columns and i cant audit the deletes in question, correct?

also, im guessing...

we dont issue direct deletes, that's the thing. we have proper cleaners (SPs) based on criteria, the problem is that somehow a rogue process somehow manages to delete rows anyways...

No, i dont want this as a permanent audit solution. i just want to catch the process that is issues those deletes.

the delete trigger crossed my mind, but because im...

i understand.

lets say this is my table, so you can use that as a reference:

TABLE [test1]

ID [int] NOT NULL,

ExpDate [datetime] NOT NULL

i want to log all the deletes from test1...

i cant give you the whole DDL of the table (i cant really understand why you need it), but i can add the specific condition of the delete i want...