I have table Contacts_Holders.
I am calling one SP to delete records from this table.
the SP take two parameters @ContactID, @HolderID
I need to write a trigger for delete on this table that will insert a record in different and put @ContactID and @holderid in to this other table.
I need to know how can my trigger takes the values which I Pass from SP and insert them into an another table on Delete/