Click here to Skip to main content
14,606,379 members

Danish Language Installation for Full Text Search Index

Rate this:
5.00 (1 vote)
Please Sign up or sign in to vote.
5.00 (1 vote)
18 Apr 2013CPOL
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

Comments and Discussions

GeneralLanguages provided by SQL Server Pin
Avelino Ferreira5-Jun-14 11:43
professionalAvelino 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.

Posted 19 Oct 2012

Tagged as


2 bookmarked