Behavior of trigger

  • Pavel Bakunovich

    SSC Veteran

    Points: 297

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

  • Ron McCullough

    SSC Guru

    Points: 63877

    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

    bitbucket-25253 (9/9/2013)


    Now I known why I detest using triggers.

    +1

  • Vinay Kumar

    SSCertifiable

    Points: 6098

    Thanks for back to basics. Good question 🙂

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

  • Koen Verbeeck

    SSC Guru

    Points: 258955

    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: 21876

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

    😉

  • PRAMANA.DBA

    SSCertifiable

    Points: 5507

    Good basic question

  • twin.devil

    SSC-Insane

    Points: 22208

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

  • call.copse

    SSCoach

    Points: 17051

    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

    SSCertifiable

    Points: 7691

    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: 6957

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

    _____________________________________________________________________
    MCSA SQL Server 2012

  • Pavel Bakunovich

    SSC Veteran

    Points: 297

    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

  • TomThomson

    SSC Guru

    Points: 104772

    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

    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