Post reply

Triggers

  • January 27, 2006 at 3:46 am

    #89253

    Hi,

    Is there anyway to disable the triggers at a transaction level is SQL server. As far I Know the answer is NO, however would like to confirm it.

    Regards

    Rajesh

     

  • January 27, 2006 at 5:50 am

    #617428

    If you want to disable the trigger globaly use

    ALTER TABLE table 

        | { ENABLE | DISABLE } TRIGGER

            { ALL | trigger_name [ ,...n ] }

    On the other hand if you want to conditionaly fire the trigger, say based on what the change is, then you could use an INSTEAD OF trigger. In the trigger code use a stored proc that you fire based on whatever condition you need.

     

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

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