December 2013
Intermediate to advanced
1872 pages
153h 31m
English
Type: Advanced
Default value: 1033
The default full-text language option is used 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 strictly dependent on the language of the data. The default value of this option is the language of the server.
The value of the default full-text language option is used when no language is specified for a column through the LANGUAGE option in the CREATE FULLTEXT INDEX or ALTER FULLTEXT INDEX statements. If the default full-text language option is not supported or the linguistic analysis package is not available, the CREATE or ALTER operation doesn’t work, and SQL Server returns an invalid language ...