Triggers (1 Viewer)

[nathansav]

Hi,

I am planning to audit certail tables in my DB using triggers.

I am new to triggers, and have got all the documentation about creating etc, but still have one question.

I wish to audit, Insert, Delete and Update. Do i create a trigger for all 3 on each table, or can i create one trigger that has all 3 involved.

Thanks in advance

NS

 

[FoFa]

You can create one trigger to monitor all three events.
How ever if you have unique code to a single event, it is usually better to break that into a separate trigger, just IMO.