Export (0) Print
Expand All
3 out of 4 rated this helpful - Rate this topic

sp_fulltext_service (Transact-SQL)

Changes Microsoft Full-Text Search for SQL (MSFTESQL) service properties.

Topic link icon Transact-SQL Syntax Conventions


sp_fulltext_service [ [@action=] 'action' 
     [ , [ @value= ] value ] ]
[ @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.

0 (success) or 1 (failure)

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

The following example updates the list of languages registered with Full-text Search.

EXEC sp_fulltext_service 'update_languages';
GO
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.