Behavior of trigger

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

  • 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]

  • bitbucket-25253 (9/9/2013)


    Now I known why I detest using triggers.

    +1

  • Thanks for back to basics. Good question 🙂

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

  • Nice question, thanks.

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

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

    😉

  • Good basic question

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

  • 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

  • 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.

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

    _____________________________________________________________________
    MCSA SQL Server 2012

  • 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

  • This was removed by the editor as SPAM

  • 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

  • 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".

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

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