sp_fulltext_service

Syntax

Arguments

Is the property to be changed or reset. action is varchar(20), with no default, and can be one of these values.

Value

Description

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.

Property

Value

resource_usage

From 1 (background) through 5 (dedicated), with a default of 3

clean_up

NULL

connect_timeout

From 1 through 32767

data_timeout

From 1 through 32767

Return Code Values

0 (success) or 1 (failure)

Result Sets

None

Remarks

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.

Permissions

Only members of the serveradmin fixed server role or the system administrator can execute sp_fulltext_service.