default full-text language Option
Use the default full-text language option to specify a default language value for full-text indexed columns. 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.
The default full-text language option requires an LCID value.
For a localized version of SQL Server, SQL Server 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 SQL Server, the default full-text language option is English.
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 SQL Server will return an error message stating that the language specified is not valid.
For a list of languages whose word breakers are registered with SQL Server, 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.
The default full-text language option is an advanced option. If you are using the sp_configure system stored procedure to change the setting, you can change default full-text language only when show advanced options is set to 1.