Click here to Skip to main content
13,195,710 members (55,581 online)
Click here to Skip to main content
Add your own
alternative version

Tagged as


2 bookmarked
Posted 19 Oct 2012

Danish Language Installation for Full Text Search Index

, 18 Apr 2013
Rate this:
Please Sign up or sign in to vote.
To avail Danish language as a language breaker in full text search index option, it has to be enabled manually by adding a registry key for the Danish language.


While working with full text search index facility provided by SQL Server there are a number of language supported by it as a language for word breaker.

The default languages it provides are:  

Arabic, Bengali (India), Brazilian, British English, Bulgarian, Catalan, Chinese (Hong Kong SAR, PRC), Chinese (Macau SAR), Chinese (Singapore), Croatian, Danish, Dutch, English, French, German, Gujarati, Hebrew, Hindi, Icelandic, Indonesian ,Italian, Japanese, Kannada, Korean, Latvian, Lithuanian, Malay – Malaysia, Malayalam, Marathi, Neutral, Norwegian (Bokmål), Polish, Portuguese, Punjabi, Romanian, Russian, Serbian (Cyrillic), Serbian (Latin), Simplified Chinese, Slovak, Slovenian, Spanish, Swedish, Tamil, Telugu, Thai, Traditional Chinese, Turkish, Ukrainian, Urdu, Vietnamese. 

MSSQL 2008 R2 does not  provide support for Danish, Polish, Turkish by default.

To avail Danish (same for other two languages also) language as a language breaker in full text search index option, it has to be enabled manually by adding a registry key for Danish.

Using the Code 

MSDN provides this facility to add language which is manual and a time consuming process. And to overcome the whole manual process, I have created a registry file that may help to add registry keys for Danish language. The attached registry file will automatically add a registry key for Danish (DanishFullTextRegistryFile.reg)

Caution: Registry contains editing

The path for default instance name is MSSQLSERVER. If the target server contains a different name then there needs change in the registry file. 

You can know your instance name by running the following query in your query window:



select * from sys.sysservers

If it is other than MSSQLSERVER, we have to make changes in DanishFullTextRegistryFile.reg file. Open the DanishFullTextRegistryFile.reg file in Notepad and find MSSQL10.MSSQLSERVER and replace it with your instance name MSSQL10_50.DEV08R2.

You can find it from the attached doc document.  

Save the registry file and run it. 

After getting a message for successful upload, we have to update the full text service. The service can be updated by running the following query: 

EXEC sp_fulltext_service @action='load_os_resources', @value=1; 

EXEC sp_fulltext_service 'update_languages';

You can check if languages are updated or not by running the below query.

sys.fulltext_languages ORDER
BY name  
--(Danish - 1030)

You will have to find out Danish language as a name and 1030 as its LCID. 

If it is available then the process runs successfully and now you can make changes to your full text search index and change the language breaker to Danish language.

(Note: This installation is only needed for the Danish version, it is not required for Swedish or English language versions.)

Thanks for reading the article, please let me know if I missed anything.


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Aadhar Joshi
India India
No Biography provided

You may also be interested in...


Comments and Discussions

GeneralLanguages provided by SQL Server Pin
Avelino Ferreira5-Jun-14 11:43
memberAvelino Ferreira5-Jun-14 11:43 
GeneralMy vote of 5 Pin
The Sql Coder26-Oct-12 1:31
memberThe Sql Coder26-Oct-12 1:31 
GeneralMy vote of 5 Pin
The Sql Coder22-Oct-12 19:57
memberThe Sql Coder22-Oct-12 19:57 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web03 | 2.8.171019.1 | Last Updated 18 Apr 2013
Article Copyright 2012 by Aadhar Joshi
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid