creating Trigger for every table in a database

[Ching Li]

Hi

Lets say I have a table MyUser (column: MyuserID, Username)

Another table Product (column: ProductID, ProductName)

Then I created a table MyUser_Audit (column: MyUserID, Username, audit_action, Audit_Timestamp ) to store all the audit trail.

And now, user01 with name Mary inserted ProductID and ProductName into the Product table.

How do I create a trigger to audit trail the action and store it into the MyUser_Audit table?


Thank you

[ck9663]

Here's primer.

Good Luck!!!

~~CK