Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    Australia
    Posts
    46

    Unanswered: Disabling Trigger within a trigger?

    Hi all,

    I would like to disable a trigger within a trigger using....

    ALTER TABLE RESIDENTIAL DISABLE TRIGGER UPDATE_SYSTEMS_RES

    However it tells me that I cant disable a trigger within one. How can I get around this or is there another way of disabling a trigger.

    Thanks
    Anthony

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    You will need to alter the code of your trigger to test if the trigger should do it's thing or bail. To my knowledge there is no way to disable a trigger from fireing while inside a trigger.
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •