sp_fulltext_service (Transact-SQL)
Changes Microsoft Full-Text Search for SQL (MSFTESQL) service properties.
.gif "Topic link icon")
Transact-SQL Syntax Conventions
Syntax
sp_fulltext_service [ [@action=] 'action'
[ , [ @value= ] value ] ]
Arguments
- [ @action=] 'action'
Is the property to be changed or reset. action is nvarchar(100), with no default. For a list of action properties, their descriptions, and the values that can be set, see the table under the values argument. This argument returns the following properties: data type, current running value, minimum or maximum value, and deprecation status, if applicable.
[ @value=] value
Is the value of the specified property. value is sql_variant, with a default value of NULL. If @value is null, sp_fulltext_service returns the current setting. This table lists action properties, their descriptions, and the values that can be set.Action Value Description clean_up
0
Supported for backward compatibility only.
connect_timeout
0
Supported for backward compatibility only.
data_timeout
0
Supported for backward compatibility only.
load_os_resources
int
1 = Load OS filters and wordbreakers.
0 = Use only filters and wordbreakers specific to this instance of SQL Server.
Indicates whether or not operating system wordbreakers, stemmers, and filters are registered and used with this instance of SQL Server. By default, this property is disabled to prevent inadvertent behavior changes by updates made to the operating system. Enabling use of OS resources provides access to resources for languages and document types registered with Microsoft Indexing Service that do not have an instance-specific resource installed. If you enable the loading of OS resources, ensure that the OS resources are trusted signed binaries; otherwise, they cannot be loaded when verify_signature (see below) is set to 1.
pause_indexing
int
Pauses full-text indexing.
resource_usage
int
Sets the MSFTESQL service administration settings, IndexingPerformanceLevel and QueryPerformanceLevel, to the same value. Values range from 1 (least aggressive) to 5 (most aggressive), with 3 as the default.
update_languages
NULL
Updates the list of languages registered with Full-text Search. The languages are specified when configuring indexing and in Full-text queries.
verify_signature
int
Indicates whether or not only signed binaries are loaded by the MSFTESQL Service. By default, only trusted, signed binaries are loaded.
1 = Verify that only trusted, signed binaries are loaded (default).
0 = Do not verify whether or not binaries are signed.
Return Code Values
0 (success) or 1 (failure)
Result Sets
None
Permissions
Only members of the serveradmin fixed server role or the system administrator can execute sp_fulltext_service.
Examples
The following example updates the list of languages registered with Full-text Search.
EXEC sp_fulltext_service 'update_languages';
GO
See Also
Reference
FULLTEXTSERVICEPROPERTY (Transact-SQL)
System Stored Procedures (Transact-SQL)