Post reply

Triggers'' working

  • March 12, 2007 at 10:22 pm

    #75137

    Dear Experts

      Can anybody please explain me how the triggers are managed by SQL Server.. i.e., when ever we create a trigger on a table will the SQL Server checks every DML statement to decide whether to execute the trigger or not.>??????....

      for ex: If we create INSERT trigger on table Table1. Then Every DML statement(INSERT, DELETE, UPDATE)s are monitored?????

    Thanks ,

    Shekhar

  • March 13, 2007 at 7:11 am

    #694666

    I'm not 100% sure, but I guess all DML statements are checked against triggers to see if they match. However the check doesn't create any load. If it does on your system, you're already overloaded.

  • March 13, 2007 at 7:21 am

    #694672

    Thank you steve

    Is there anyway to check the load caused by the triggers???..

    and how SQL server decides which trigger to execute first if we have 2 same INSERT(UPDATE/DELETE) triggers??..

    Thanks ,

    Shekhar

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply