How to: Set the Default Full-Text Language (SQL Server Management Studio)

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.

To set the default full-text language

  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.