Re: Disabling triggers

From: Vinodk (vinodk_sct_at_NO_SPAM_hotmail.com)
Date: 10/01/04 

Date: Fri, 1 Oct 2004 17:08:17 +0530

Use the ALTER TABLE <table Name> DISABLE TRIGGER <trg Name> 

-- 
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
http://groups.msn.com/SQLBang
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
"Phil Davy" <anonymous@discussions.microsoft.com> wrote in message
news:212e01c4a7a9$9eaa5090$a401280a@phx.gbl...
> Does anyone know if there is/are a T-SQL command(s) to
> temporarily disable a trigger?  (a bit like SET ANSI
> NULLS OFF/ON) ?
>
> All I can think of doing is editing the existing trigger
> with a "return" statement at the start.
>
> Or I could drop it, however then I will need to recreate
> it.
>
> So if possible I prefer the solution of temporily
> disabling it.
>
> Can anyone help please?
>
> Thanks
> Phil

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
    ... ALTER TABLE DISABLE TRIGGER ALL | ... Net Asset Management ... "Phil Davy" wrote in message ... > disabling it. ...
    (microsoft.public.sqlserver.programming)