CREATE A DISABLED TRIGGER

[fmsousa]

Hi,

I would like to know how can i create a trigger disabled.
If i do like this:
CREATE TRIGGER xpto...

it stays enabled. there is any possibility of creating directly a trigger at disabled mode.

Thanks in advance!

 

[SpiritOfLennon]

You would think so wouldn't you. I had this same issue last week, unfortunately I had to wait until the database was not in use ( lucky it's not 24-7 ) before doing so. I think the problem is that on compilation it has to enable to check it's validation, however I could be wrong. SOL
I'm only guessing but my guess work generally works for me.

 

[mesuj]

why do you want to create a trigger that is disabled. check it like a normal SP for business logic. then when you close down for maintenance you can create and disable it.
seriuous i don't understand the need for a disabled trigger

 

[pikkiorock]

I'm completely agree with Mesuj