asked
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
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][1] to understand what you can do with multiple languages on the system. [1]:
http://www.google.com/url?sa=t&rct=j&q=&esrc=s&frm=1&source=web&cd=1&ved=0CC4QFjAA&url=http%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fms142795.aspx&ei=0yvrTt_eCaTl0QHOxNSsCQ&usg=AFQjCNFMBNc9zyj9N9lfGaK8Q5m7ZSQBgA&sig2=KXhBXMEzmuxnCKhbsCRM3w
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?
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.
