I have defined an SQL Trigger AFTER DELETE 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, only found EVENTDATA() for Logon-Triggers and COLUMNS_UPDATED(), but nothing related to DELETE triggers…
2