Hello Everyone!
Can anyone suggest me, the best way to log table's transactions?
Right now, I just fired a trigger for following operations INSERT, UPDATE, DELETE on a table like 'Table1' and this trigger insert a new row in another table like 'Table1_Trail' on each and every operation.
Is this a good option to log table's transactions?
Thanks in advance.
Lakhan Singh
Tech Lead
BeyondKey System Pvt. Ltd.
Indore, M.P.
India