SYSLanguages on SQL 2012

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Henrico Bekker » SYSLanguages on SQL 2012

24 posts, Page 1 of 3

1 2 3 »»»

SYSLanguages on SQL 2012

Rate Topic

Display Mode

Topic Options

Author

Message

Henrico Bekker

Posted Saturday, May 12, 2012 4:08 PM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:24 AM
Points: 1,871, Visits: 2,692

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

----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.

Post #1299170

bitbucket-25253

Posted Saturday, May 12, 2012 4:09 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 5:16 PM
Points: 5,101, Visits: 20,201

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
Before posting a performance problem please read

Post #1299171

baabhu

Posted Monday, May 14, 2012 12:12 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 1:58 AM
Points: 1,112, Visits: 970

+1. Thanks for the easy question.

Post #1299360

Nakul Vachhrajani

Posted Monday, May 14, 2012 1:39 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:52 AM
Points: 1,277, Visits: 1,608

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

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://beyondrelational.com/modules/2/blogs/77/nakuls-blog.aspx
Be courteous. Drive responsibly.

Follow me on
Twitter: @nakulv_sql
Google Plus: +Nakul

Post #1299398

Stewart "Arturius" Campbell

Posted Monday, May 14, 2012 1:51 AM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 3:48 AM
Points: 3,125, Visits: 4,311

Good question, thanks

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Post #1299400

DugyC

Posted Monday, May 14, 2012 3:33 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 5:21 AM
Points: 1,162, Visits: 728

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

_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"

Post #1299422

L' Eomot Inversé

Posted Monday, May 14, 2012 4:13 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 5:48 PM
Points: 7,088, Visits: 7,143

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
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)

Post #1299438