Home Forums Article Discussions Article Discussions by Author Discuss content posted by Tejas Shah Access variables values from Trigger RE: Access variables values from Trigger

  • June 9, 2010 at 9:09 am

    #1178027

    christopher.cormier (6/9/2010)

    This may be a faily easy quesion, but aside from the business requirement are there any performance benefits of putting the audit trail in a trigger? I'm fairly new to SQL, but if the only way for users to delete a record is to use the mentioned stored procedure I think I would leave the audit trail piece in the procedure itself.

    Are there any performance/security benefits of using triggers for audit trails?

    Thanks!

    We use the exact same method for auditing of deletions. Triggers are used to audit the row deletions of related (i.e., child) tables via a Foreign Key (FK) cascade delete. A very common situation. Especially in a hierarchical tree structure.

    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]