Changes Microsoft® Search Service (Full-text Search) properties.
sp_fulltext_service [@action =] 'action'
[ , [ @value = ] 'value' ]
[@action =] 'action'
Is the property to be changed or reset. action is varchar(20), with no default, and can be one of these values.
|resource_usage||Specifies the amount of resources to be used for the Microsoft Search Service.|
|clean_up||Searches for and removes the full-text catalog resources in the file system that do not have corresponding entries in sysfulltextcatalogs.|
|connect_timeout||Is the number of seconds that Microsoft Search Service will wait for connections to Microsoft® SQL Server™ for full-text populations before timing out.
If a time-out occurs before SQL Server responds to a database request, the population fails to complete.
|data_timeout||Is the number of seconds that Microsoft Search Service will wait for data to be returned by the SQL Server database server for full-text index population before timing out. If a time-out occurs before SQL Server responds to a database request, the index population will not complete.|
[@value =] 'value'
Is the value of the specified property. value is int, with a default value of NULL. This table shows the required values for the properties.
|resource_usage||From 1 (background) through 5 (dedicated), with a default of 3|
|connect_timeout||From 1 through 32767|
|data_timeout||From 1 through 32767|
Return Code Values
0 (success) or 1 (failure)
There may be times when the metadata for a full-text catalog is changed (for example, when the full-text catalog is dropped or the database is dropped) while the Microsoft Search Service (MSSearch) is not running. The drop action changes the metadata related to the full-text catalogs but is unable to complete execution because the Microsoft Search Service is not running. This leads to inconsistency between the full-text metadata in SQL Server and the associated physical full-text catalog in the file system. This inconsistency can be corrected by using the clean_up action of sp_fulltext_service. Microsoft Search Service must be running.
Only members of the serveradmin fixed server role or the system administrator can execute sp_fulltext_service.
This example performs a cleanup operation on the full-text catalogs.
EXEC sp_fulltext_service 'clean_up'