I have defined an AFTER DELETE
SQL trigger on a table and I want to store information in another table. Therefore, I would like to also store the SQL statement that triggered the trigger. Is there a way to access this statement? Or something similar? I just don’t want to retrieve all that information by hand. Also, I might want to use the trigger on different tables.
I googled a lot, and only found EVENTDATA()
for logon-triggers and COLUMNS_UPDATED()
, but nothing related to delete triggers.
4