x
login about faq Site discussion (meta-askssc)

How to add a language to SQL Server 2008 R2

Hi,

I have been trying to add a language to SQL, but I am having no luck. I tried using sp_addlanguage, but it says that it is not found. I have read that it was deprecated, so now I am confused.

Is the following no longer available?

exec sp_addlanguage french, null, 'janvier,fevrier,mars,avril,mai,juin,juillet, aout,septembre,octobre,novembre,decembre', 'jan,fev,mars,avr,mai,juin,jui,aout,sept,oct, nov,dec', 'lundi,mardi,mercredi,jeudi,vendredi,samedi, dimanche', dmy, 1

How do I add a language to SQL?

Regards, Pierre

more ▼

asked Dec 16 '11 at 03:11 AM in Default

Skaap gravatar image

Skaap
11 1 1 1

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

In general you're going to be able to control the language during a localized install of the product and for full text indexing. Other than that, I'd suggest reading through this section of the Books Online to understand what you can do with multiple languages on the system.

more ▼

answered Dec 16 '11 at 03:27 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
62.1k 12 20 66

(comments are locked)
10|1200 characters needed characters left

I want to use: SET LANGUAGE Ukrainian SELECT DATENAME(month, @Today) AS 'Month Name'

Ukrainian does not exist, so I would like to add it using sp_addlanguage, but that does not exist anymore, so how do I add the language?

more ▼

answered Dec 16 '11 at 03:35 AM

Skaap gravatar image

Skaap
11 1 1 1

It's my understanding that language support in SQL Server derives from the underlying operating system (except for the localized install and full text support). I'd start there. Again, the BOL section I sent you to will help.

Dec 16 '11 at 03:38 AM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x599
x4
x2

asked: Dec 16 '11 at 03:11 AM

Seen: 1155 times

Last Updated: Dec 16 '11 at 03:11 AM

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.