Online Documentation for SQL Administrator for SQL Server

Full-text search


The Full-text search section of the Server Properties dialog allows you to configure the instance of Microsoft® SQL Server by setting options of full-text queries that perform linguistic searches

 

Server properties - Full-text search

 

 

Default full-text language

Full-text queries perform linguistic searches against text data in full-text indexes by operating on words and phrases based on rules of a particular language. Use the drop-down list to specify this language.

 

Full-text catalog upgrade option

!RadioButton Rebuild

Full-text catalogs are rebuilt using the new and enhanced word breakers. Rebuilding indexes can take awhile, and a significant amount of CPU and memory might be required after the upgrade.

 

!RadioButton Reset

Full-text catalogs are reset. SQL Server full-text catalog files are removed, but the metadata for full-text catalogs and full-text indexes is retained. After being upgraded, all full-text indexes are disabled for change tracking and crawls are not started automatically. The catalog will remain empty until you manually issue a full population, after the upgrade completes.

 

!RadioButton Import

Full-text catalogs are imported. Typically, import is significantly faster than rebuild. For example, when using only one CPU, import runs about 10 times faster than rebuild. However, an imported full-text catalog does not use the new and enhanced word breakers introduced in SQL Server 2008, so you might want to rebuild your full-text catalogs eventually.