Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

SYSLanguages on SQL 2012 Expand / Collapse
Author
Message
Posted Saturday, May 12, 2012 4:08 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, August 28, 2014 2:39 AM
Points: 1,880, Visits: 2,846
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
Posted Saturday, May 12, 2012 4:09 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, November 6, 2014 1:00 PM
Points: 5,333, Visits: 25,277
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
Posted Monday, May 14, 2012 12:12 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 8:31 PM
Points: 1,302, Visits: 1,147
+1. Thanks for the easy question.
Post #1299360
Posted Monday, May 14, 2012 1:39 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Yesterday @ 10:22 PM
Points: 1,457, Visits: 1,858
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
Be courteous. Drive responsibly.

Follow me on
Twitter: @sqltwins
Google Plus: +Nakul
Post #1299398
Posted Monday, May 14, 2012 1:51 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 1:08 AM
Points: 4,160, Visits: 5,557
Good question, thanks

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1299400
Posted Monday, May 14, 2012 3:33 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 27, 2013 4:28 AM
Points: 1,248, Visits: 779
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...


_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #1299422
Posted Monday, May 14, 2012 4:13 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 4:21 PM
Points: 7,928, Visits: 9,653
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
Post #1299438
Posted Monday, May 14, 2012 5:51 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, December 18, 2014 2:55 AM
Points: 1,262, Visits: 13,558
nice question!!!
thanks!



rfr.ferrari
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
Post #1299487
Posted Monday, May 14, 2012 8:17 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 8:17 PM
Points: 3,417, Visits: 2,036
Thanks for the question.
Post #1299592
Posted Monday, May 14, 2012 9:15 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, October 24, 2014 12:43 PM
Points: 4,126, Visits: 3,428
An easy one to start the week - thanks!
Post #1299639
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse