Whats going on Query window?

Question

Whats going on Query window?

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

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

timwell SSCertifiable Points: 5315 More actions · Answer 1

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: 740 More actions · Answer 2

vivekjamshedpur

Right there with Babe

Points: 740

December 12, 2014 at 8:51 am

#1764457

+1

TomThomson SSC Guru Points: 104773 More actions · Answer 3

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: 182911 More actions · Answer 4

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: 13921 More actions · Answer 5

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

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 6

akljfhnlaflkj

SSC Guru

Points: 76202

December 15, 2014 at 3:29 pm

#1764812

Thanks for the question.

manik_anu SSCrazy Points: 2377 More actions · Answer 7

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 More actions · Answer 8

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.