Introduction
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 @@SERVERNAME OR
SELECT SERVERPROPERTY('InstanceName') OR
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.
SELECT * FROM
sys.fulltext_languages ORDER
BY name
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.
