Whats going on Query window?

  • timwell

    SSCertifiable

    Points: 5055

    Sean Lange (12/12/2014)


    ... Also, the link for documentation is a pretty bad choice since it is the sql 2000 version. There is no reference at all to sp_configure. ...

    A better reference would be the 2008 R2 description of "ALLOW UPDATES" (http://msdn.microsoft.com/en-us/library/ms179262(v=sql.105).aspx) where it says:

    This option is still present in the sp_configure stored procedure, although its functionality is unavailable in SQL Server. The setting has no effect. Starting with SQL Server 2005, direct updates to the system tables are not supported.

  • vivekjamshedpur

    Right there with Babe

    Points: 734

    +1

  • TomThomson

    SSC Guru

    Points: 104773

    Another nice question spoilt by bad wording. Interesting, though, and easy to work out what the third tick had to be although it certainly didn't appear as output as required by the question's wording.

    Tom

  • Eirikur Eiriksson

    SSC Guru

    Points: 182438

    Thank you for the question Shiva, straight forward even if the wording could have been more precise;-)

    Another interesting thing is that the option "ALLOW UPDATES" is depreciated and has in fact no functionality since SQL Server 2005, as direct update of system tables is not supported in 2005 and later versions.

    😎

  • Hany Helmy

    SSChampion

    Points: 13488

    Well, I am using sp_configure often, but I never included it in a transaction, what is the use of that anyway? 😎

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the question.

  • manik_anu

    SSCrazy

    Points: 2367

    Stewart "Arturius" Campbell (12/12/2014)


    Heals (12/12/2014)


    However, the question seems to be worded incorrectly - if you run this code against SQL 2008R2 you only get two messages come back (At least I did when I checked my instance).

    +1

    at least I learned something today - read the question carefully before answering, and then only after the first cup of coffee...:-D

    +1 thanks

    Manik
    You cannot get to the top by sitting on your bottom.

  • Mat Cooke

    Valued Member

    Points: 67

    Logic can answer this question...

    5 answers... Pick 3 ... 2 of them would indicate success which rules them out... Leaving the 3 that you should select.

Viewing 8 posts - 16 through 23 (of 23 total)

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