Question on disabling Triggers
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
Next message: Greg: "Just starting out, need advice"
Date: Thu, 9 Dec 2004 02:13:23 -0800
Another solution might be to lock the table for the
duration of the procedure. In this case no update can
happen while de trigger is disabled.
I know this isn't a very nice solution but disabling
triggers on the fly isn't either.
Next message: Greg: "Just starting out, need advice"
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) - 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) |
|
