SYSLanguages on SQL 2012

  • Comments posted to this topic are about the item SYSLanguages on SQL 2012

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • Nice way to start the week.

    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]

  • +1. Thanks for the easy question.

  • Thank-you, for the nice & easy question. For me, the week generally goes good if the start is good 🙂

    I have strongly believed that if users are not supposed to use something, they should not be able to access it.

    The "allow updates" option has been marked as deprecated. Setting it to 1 results in a few other issues also (http://beyondrelational.com/modules/2/blogs/77/posts/11282/ad-hoc-update-to-system-catalogs-is-not-supported-when-using-reconfigure.aspx)

    While the deprecation of "allow updates" from the options list may take a couple of releases, I had raised a Connect item to at least move this into the "advanced options" list (https://connect.microsoft.com/SQLServer/feedback/details/662305/sp-configure-allow-updates-should-be-an-advanced-option#details). However the item was marked as "Won't Fix".

    Thanks & Regards,
    Nakul Vachhrajani.
    http://nakulvachhrajani.com

    Follow me on
    Twitter: @sqltwins

  • This was removed by the editor as SPAM

  • Good question to start the week, thanks.

    Spent time researching thinking there must be a trick in there somewhere, but in the end went with what I knew and phew! got it right... 😀

    _____________________________________________________________________
    [font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

  • Good question.

    It's a pity the script used in the explanation didn't include "RECONFIGURE WITH OVERRIDE

    GO" like the script in the question. The absence of the reconfigure statement after the sp_configure call has generated a message saying that reconfigure has to be used to give effect to the sp_configure arguments might suggest to some readers that this is the reason for the update statement failing, which it clearly isn't. In fact Bol suggests that the (first) RECONFIGURE command would fail anyway, and it would have been nice if the script in teh explanation had shown this failure.

    Tom

  • nice question!!!

    thanks!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • Thanks for the question.

  • An easy one to start the week - thanks!

  • Thanks for the question. I'd like to see more questions on sys tables/views. Please.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • nice one to start the week - cheers

  • I'd have thought more people would have gotten this one right. Only 60% at this time, sorry but that's low for this question imho.

  • Lynn Pettis (5/14/2012)


    I'd have thought more people would have gotten this one right. Only 60% at this time, sorry but that's low for this question imho.

    I agree. It seems unlikely that 40% of people are unaware that this has changed since SQL Server 2000, and there's no other sensible reason for anyone to get it wrong.

    Tom

  • Lynn Pettis (5/14/2012)


    I'd have thought more people would have gotten this one right. Only 60% at this time, sorry but that's low for this question imho.

    Quite surprised myself....well hopefully someone learned something from this easy yet (looks like?) challenging question.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

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

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