Post reply

Trigger Recompiling

  • November 17, 2005 at 9:37 am

    #166344

    I have a trigger that is rarely used, but necessary on a particular column.  The problem is the table is updated frequently, and the trigger goes through the recompile event quite often, quite unnecessarily.  Is there any way to event this? 

    thanks for any input.

  • November 17, 2005 at 10:10 pm

    #604559

    Hi , when will the trigger get fired ? I mean , on which event (insert,update,delete) it gets fired?

    With Kind Regards,

    M.S.Balavijay

  • November 18, 2005 at 12:36 am

    #604561

    Hi, You can use if Update(field) clause in your trigger.

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

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