SYSLanguages on SQL 2012

Question

SYSLanguages on SQL 2012

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

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

SimonLiew SSCrazy Eights Points: 8293 More actions · Answer 1

errr.. the explaination says you cant update system tables on sql 2005 onwards. is this description really true?

I'm not saying its a good practice and Microsoft definitely doesnt support the case if you've modified system tables, but ..

http://sqlserver-qa.net/blogs/tools/archive/2007/04/24/sql-server-2005-ad-hoc-updates-to-system-catalogs-are-not-allowed.aspx

Simon

Simon Liew
Microsoft Certified Master: SQL Server 2008

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

Simon-413722 (5/14/2012)
errr.. the explaination says you cant update system tables on sql 2005 onwards. is this description really true?
I'm not saying its a good practice and Microsoft definitely doesnt support the case if you've modified system tables, but ..
http://sqlserver-qa.net/blogs/tools/archive/2007/04/24/sql-server-2005-ad-hoc-updates-to-system-catalogs-are-not-allowed.aspx
Simon

Considering the hoops you to go through, I would say that it is basically not supported, especially the way you used to be able to update the system tables. It would definately take some effort to accomplish.

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 3

L' Eomot Inversé (5/14/2012)
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.

Other (maybe even more likely) reasons include never having worked with SQL Server 2000 or older (not everyone on this site has a 5+-year experience in SQL Server), or never having considered changing system tables until this question was published.

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Toreador SSChampion Points: 11365 More actions · Answer 4

I knew the answer, but if I hadn't then a reasonable guess would have been that it would work - on the basis that it makes sense to have a command that could never work. I'm still not sure why MS decided not to remove the option completely.

Robin Sasson Hall of Fame Points: 3359 More actions · Answer 5

Good question thanks. I must admit though my answer was more luck than judgement but hey, I've learn't something too!

:exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

nice question - thanks

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 7

Nice question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Britt Cluff SSCertifiable Points: 5083 More actions · Answer 8

Good question. Thanks for submitting.

http://brittcluff.blogspot.com/

Neha05 Default port Points: 1494 More actions · Answer 9

Neha05

Default port

Points: 1494

August 9, 2012 at 9:13 am

#1523874

Good question, thanks!