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

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

Skaap
11 ● 1 ● 1 ● 1

(comments are locked)

3 answers:

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.

answered Dec 16 '11 at 03:27 AM

Grant Fritchey ♦♦
62.4k ● 12 ● 20 ● 66

(comments are locked)

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?

answered Dec 16 '11 at 03:35 AM

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)