September 9, 2013 at 8:25 pm
Comments posted to this topic are about the item Behavior of trigger
September 9, 2013 at 8:50 pm
September 9, 2013 at 11:29 pm
bitbucket-25253 (9/9/2013)
Now I known why I detest using triggers.
+1
September 9, 2013 at 11:33 pm
Thanks for back to basics. Good question
Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
September 10, 2013 at 12:45 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 10, 2013 at 12:51 am
Unusual altering a disabled trigger, but it's good to know!
September 10, 2013 at 1:26 am
Good basic question
September 10, 2013 at 2:09 am
good question ... people tends to forget these basics !!!
September 10, 2013 at 2:11 am
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
September 10, 2013 at 2:47 am
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.
September 10, 2013 at 3:50 am
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
September 10, 2013 at 5:57 am
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
September 10, 2013 at 7:27 am
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".
September 10, 2013 at 8:08 am
bitbucket-25253 (9/9/2013)
Now I known why I detest using triggers.
Yet another reason. What a horrible design decision. :blink:
Viewing 15 posts - 1 through 15 (of 31 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy