| title | Configure the default full-text language (server configuration option) | ||
|---|---|---|---|
| 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. | ||
| author | rwestMSFT | ||
| ms.author | randolphwest | ||
| ms.date | 03/02/2017 | ||
| ms.service | sql | ||
| ms.subservice | configuration | ||
| ms.topic | conceptual | ||
| helpviewer_keywords |
|
[!INCLUDE SQL Server]
This topic describes how to configure the default full-text language server configuration option in [!INCLUDEssnoversion] 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:
-
To configure the default full-text language option, using:
-
Follow Up: After you configure the default full-text language option
- 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.
-
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 is found, the Full-Text Engine will automatically switch to the primary language.
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.
-
In Object Explorer, right-click a server and select Properties.
-
Click the Advanced node.
-
Under Miscellaneous, use Default Full Text Language to specify a default language value for full-text indexed columns.
-
Connect to the [!INCLUDEssDE].
-
From the Standard bar, click New Query.
-
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-textoption to Dutch (1043).
USE AdventureWorks2022;
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).
The setting takes effect immediately without restarting the server.
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)