disabling trigger

[fixthebug2003]

Hi ,
is there a way is disable and enable a trigger on a table in SQL server..is so..how?
Thanks
Fixthebug2003

 

[joebickley]

permenantly or just for a life of a proc?

 

[fixthebug2003]

Permenantly would be to DROP the trigger... !

I said DISABLE ..meaning Trigger exists in the database as an object ..but does not fire..!

And what do you mean "just for a life of a proc"?

Thanks,
fixthebug2003

 

[joebickley]

Calm down was only trying to understand ur use of it.
life of a proc as in if u had a proc doing a load of stuff and u didnt want any triggers to fire while it was doing it.


ALTER TABLE tableX DISABLE TRIGGER triggerY

that will do it

ALTER TABLE tableX ENABLE TRIGGER triggerY

strangly enough turns it back on

 

[sneki]

-- Disable the trigger.
ALTER TABLE tableName DISABLE TRIGGER triggerName
.
.
.
code
.
.
.
-- Re-enable the trigger.
ALTER TABLE tableName ENABLE TRIGGER triggerName

 

[joebickley]

Hey no fair i told him first

 

[sneki]

no, no )

 

[fixthebug2003]

thanks Joebickley....and sneki too ! Although Joe was first!