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
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.