Creating trigger to log insert action problem
920164Mar 18 2012 — edited Mar 20 2012Hi all;
I just want to ask, is it possible to create a trigger to log that an "Insert" action on a table has been made along with the value of a certain column from this table without using the [FOR EACH ROW] statement, My problem is that i have a table [A] where more than one record can be inserted at the same time for a certain ID, an auditing functionality is required on this table, the audit info will be stored in another table "log table", but to reduce the number of inserted records into the "log table" i just want to log that an insert has happened in table [A] for this specific id, after that, if someone is intrested, he can go back to the actual table to see the acutal inserted records.
Thanks in advance