How to: View or Change Server Properties for Full-Text Search (SQL Server Management Studio)
You can view the full-text properties of an instance of SQL Server in SQL Server Management Studio.
To view and change server properties for full-text search
In Object Explorer, right-click a server, and then click Properties.
In the Server Properties dialog box, click the Advanced page to view server information about full-text search. The full-text properties are as follows:
Default Full-Text Language
Specifies a default language for full-text indexed columns. Linguistic analysis of full-text indexed data is dependent on the language of the data. The default value of this option is the language of the server. For the language that corresponds to the displayed setting, see sys.fulltext_languages (Transact-SQL).
For more information about this server property, see default full-text language Option.
Full-Text Upgrade Option
This server property controls how full-text indexes are migrated when upgrading a database from SQL Server 2000 or SQL Server 2005 to SQL Server 2008 or later version. This property applies to upgrading by attaching a database, restoring a database backup, restoring a file backup, or copying the database by using the Copy Database Wizard.
The alternatives are as follows:
For information about choosing a full-text upgrade option, see full-Full-Text Search Upgrade.
The full-text upgrade option can also be set by using the sp_fulltext_service upgrade_option action.