Behavior of trigger

Question

Post reply

Behavior of trigger

Pavel Bakunovich

SSC Veteran

Points: 297
More actions
September 9, 2013 at 8:25 pm

#282924

Comments posted to this topic are about the item Behavior of trigger

Viewing 15 posts - 1 through 15 (of 31 total)

You must be logged in to reply to this topic. Login to reply

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

Now I known why I detest using triggers.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Mr. Kapsicum SSCertifiable Points: 6128 More actions · Answer 2

bitbucket-25253 (9/9/2013)
Now I known why I detest using triggers.

+1

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 3

Thanks for back to basics. Good question

Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!

Koen Verbeeck SSC Guru Points: 259155 More actions · Answer 4

Nice question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Carlo Romagnano SSC-Insane Points: 22750 More actions · Answer 5

Unusual altering a disabled trigger, but it's good to know!

PRAMANA.DBA SSCertifiable Points: 5507 More actions · Answer 6

PRAMANA.DBA

SSCertifiable

Points: 5507

September 10, 2013 at 1:26 am

#1648735

Good basic question

Umer Akram SSC-Insane Points: 22209 More actions · Answer 7

good question ... people tends to forget these basics !!!

call.copse SSCoach Points: 18142 More actions · Answer 8

Oooh! I knew this one. Thus it must be an easy one

Still, I will only use triggers as a last resort in general, or as in the example for some kinds of logging - it still seems the best choice in a few logging circumstances.

-Iain

Rune Bivrin SSCrazy Eights Points: 8595 More actions · Answer 9

Nice job linking to the Russian language online docs...

However, there is nothing in that text which says anything about whether ALTER TRIGGER affects the enable/disable state of the trigger.

Just because you're right doesn't mean everybody else is wrong.

Richard Warr SSCertifiable Points: 6968 More actions · Answer 10

I found some supporting documentation here. Seems a bit of a "hidden gem" though :crazy:

Pavel Bakunovich SSC Veteran Points: 297 More actions · Answer 11

Rune Bivrin (9/10/2013)
Nice job linking to the Russian language online docs...
However, there is nothing in that text which says anything about whether ALTER TRIGGER affects the enable/disable state of the trigger.

I didn't find any documentation about this behavior, and just put this common link. I don't know, maybe it is a bug or feature. Thanks Richard Warr finding something about this behavior

TomThomson SSC Guru Points: 104773 More actions · Answer 12

Nice question that illustrates an interesting undocumented feature.

Richard Warr (9/10/2013)
I found some supporting documentation here. Seems a bit of a "hidden gem" though :crazy:

Back in May Microsoft said this was by design and they were going to document in BOL, and in June they said it would take a couple of weeks to make the change. (see this connect entry).

Twelve weeks on it's still not documented in BOL (not even for SQL 2014). I wonder if they've forgotten?

edit: get link tags right

Tom

Jeff.MSSqlSage Say Hey Kid Points: 709 More actions · Answer 13

You guys certainly have an interesting definition of what defines "basics".

I don't think an undocumented feature of the ALTER TRIGGER functionality qualifies as "basics".

sestell1 SSChampion Points: 10230 More actions · Answer 14

bitbucket-25253 (9/9/2013)
Now I known why I detest using triggers.

Yet another reason. What a horrible design decision. :blink:

Behavior of trigger

Cookies on SQLServerCentral