Skip to content

configure-the-default-full-text-language-server-configuration-option.md

Latest commit

 

History

History
105 lines (70 loc) · 6.24 KB

configure-the-default-full-text-language-server-configuration-option.md

File metadata and controls

105 lines (70 loc) · 6.24 KB
title Configure the default full-text language Server Configuration Option | Microsoft Docs
description Learn about the default full-text language option. See how to configure it to specify the default language that SQL Server uses for full-text indexes.
ms.custom
ms.date 03/02/2017
ms.prod sql
ms.prod_service high-availability
ms.reviewer
ms.technology configuration
ms.topic conceptual
helpviewer_keywords
languages [full-text search]
default full-text language option
ms.assetid 0fa8785b-0830-4a52-aff5-fcf8268b72fc
author markingmyname
ms.author maghan

Configure the default full-text language Server Configuration Option

[!INCLUDE SQL Server]

This topic describes how to configure the default full-text language server configuration option in [!INCLUDEssCurrent] by using [!INCLUDEssManStudioFull] or [!INCLUDEtsql]. The default full-text language option specifies a default language value for full-text indexes. Linguistic analysis is performed on all data that is full-text indexed and is dependent on the language of the data. The default value of this option is the language of the server. For a localized version of [!INCLUDEssNoVersion], [!INCLUDEssNoVersion] Setup sets the default full-text language option to the language of the server if an appropriate match exists. For a non-localized version of [!INCLUDEssNoVersion], the default full-text language option is English.

In This Topic

Before You Begin

Limitations and Restrictions

  • The value of the default full-text language option is used in a full-text index when no language is specified for a column through the LANGUAGE language_term option in the CREATE FULLTEXT INDEX or ALTER FULLTEXT INDEX statements. If the default full-text language is not supported or the linguistic analysis package is not available, the CREATE or ALTER operation will fail and [!INCLUDEssNoVersion] will return an error message stating that the language specified is not valid.

Recommendations

  • This option is an advanced option and should be changed only by an experienced database administrator or certified [!INCLUDEssNoVersion] professional.

  • The default full-text language option requires an LCID value. For a list of supported LCIDs and their related languages, see sys.fulltext_languages (Transact-SQL). Other languages may also be available from independent software vendors, for example. If no specific language dialect is found, the Full-Text Engine will automatically switch to the primary language.

Security

Permissions

Execute permissions on sp_configure with no parameters or with only the first parameter are granted to all users by default. To execute sp_configure with both parameters to change a configuration option or to run the RECONFIGURE statement, a user must be granted the ALTER SETTINGS server-level permission. The ALTER SETTINGS permission is implicitly held by the sysadmin and serveradmin fixed server roles.

Using SQL Server Management Studio

To configure the default full-text language option

  1. In Object Explorer, right-click a server and select Properties.

  2. Click the Advanced node.

  3. Under Miscellaneous, use Default Full Text Language to specify a default language value for full-text indexed columns.

Using Transact-SQL

To configure the default full-text language option

  1. Connect to the [!INCLUDEssDE].

  2. From the Standard bar, click New Query.

  3. Copy and paste the following example into the query window and click Execute. This example shows how to use sp_configure to set the value of the default full-text option to Dutch (1043).

USE AdventureWorks2012 ;  
GO  
EXEC sp_configure 'show advanced options', 1 ;  
GO  
RECONFIGURE  
GO  
EXEC sp_configure 'default full-text language', 1043 ;  
GO  
RECONFIGURE  
GO

For more information, see Server Configuration Options (SQL Server).

Follow Up: After you configure the default full-text language option

The setting takes effect immediately without restarting the server.

See Also

sys.fulltext_languages (Transact-SQL)
RECONFIGURE (Transact-SQL)
Server Configuration Options (SQL Server)
sp_configure (Transact-SQL)
CREATE FULLTEXT INDEX (Transact-SQL)
ALTER FULLTEXT INDEX (Transact-SQL)