By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,926 Members | 1,806 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,926 IT Pros & Developers. It's quick & easy.

creating Trigger for every table in a database

P: 1

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
Apr 9 '11 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 2,878
Here's primer.

Good Luck!!!

Apr 13 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.