Need help!!!

Hi,

Can some one tell me how can I disable a trigger when it is being
called?

Please find the details about the setup:

I have create a trigger T1 for the table TAB1 in the schema A in the
database D1 and similarly I have create a trigger T2 for the table
TAB2 in the schema B in the database D2.

This setup was done inorder to update any transaction that happens
locally say TAB1 in the remote database table TAB2.

I have create the procedures to update the transaction in the other
database.

However, while testing, I tried to insert/update manually, I am
getting the error like primary key constraint voilated.

Hence I disable the trigger at the remote database and tried to
update/insert. It worked fine.

There are no problem with delete even when both the triggers are
enabled.

Hence in order to automatically disable the trigger in the remote
database when it is receiving some updates from the local database. It
should get disabled and once the update is done. it should get
enabled.

This disabling and enabling should occur only when it is coming from
the other database. If anything happens locally, this process should
occur. It should go in a normal manner.


Please provide me some solution for this or let me know how to disable
the trigger when it is being fired and starts executing the
procedures.

Thanks in Advance!!!

.

Relevant Pages

  • Re: Need help!!!
    ... I have create a trigger T1 for the table TAB1 in the schema A in the ... TAB2 in the schema B in the database D2. ... Hence I disable the trigger at the remote database and tried to ... This disabling and enabling should occur only when it is coming from ...
    (comp.databases.oracle.server)
  • Need help!!!
    ... I have create a trigger T1 for the table TAB1 in the schema A in the ... TAB2 in the schema B in the database D2. ... This setup was done inorder to update any transaction that happens ... This disabling and enabling should occur only when it is coming from ...
    (comp.databases.oracle.server)
  • Re: FreeBSD unstable on Dell 1750 using SMP?
    ... The problems I was experiencing were on a dual Xeon with HTT enabled as well. ... Perhaps someone out there who knows much more about the inner workings of FreeBSD may have an idea of why running top in "aggressive mode" like this might trigger the random rebooting. ... In any case, I'm anxious to try it out myself on our server to see if "top -s0" brings it down "on command" with HTT enabled, and not with HTT disabled. ... disabling HTT as I've done seems like a reasonable precaution to improve the stability.. ...
    (freebsd-stable)
  • Re: Disabling triggers
    ... Use the ALTER TABLE DISABLE TRIGGER ... Books Online for SQL Server SP3 at ... "Phil Davy" wrote in message ... > disabling it. ...
    (microsoft.public.sqlserver.programming)
  • Re: role/permissions to allow SELECT and creating and deleting triggers
    ... grant create trigger, alter trigger to MyUser ... Columnist, SQL Server Professional ... I'm trying to figure out how to setup a role (or just give a user ... since it's only 1 user) on a particular database to have SELECT ...
    (microsoft.public.sqlserver.security)