How to change the language of sql server 2005

Question

Viewing 7 posts - 1 through 6 (of 6 total)

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

ss-457805 SSCertifiable Points: 5872 More actions · Answer 1

EXEC sp_configure 'default language', 23

RECONFIGURE

You can then check:

SELECT @@language, @@langid

SQL Dev-938873 Ten Centuries Points: 1280 More actions · Answer 2

I did that,

i changed from us_english to french

But when you saw the server options ( right click on server ).

They showing us_english only..

not reflected...

GaNeSH

ss-457805 SSCertifiable Points: 5872 More actions · Answer 3

I don't think you can change the Server language (May be the experts here can share more light on this).You can change it for individual logins.

SQL Dev-938873 Ten Centuries Points: 1280 More actions · Answer 4

is it..

can you plz tell me how to set individual logins...

GaNeSH

ss-457805 SSCertifiable Points: 5872 More actions · Answer 5

To change the default language of a login, you can use sp_defaultlanguage or

ALTER LOGIN sa WITH DEFAULT_LANGUAGE = British;

GO

SQL Dev-938873 Ten Centuries Points: 1280 More actions · Answer 6

Ten Centuries

Points: 1280

June 24, 2009 at 4:53 am

ThanQ

GaNeSH