sp_fulltext_service (Transact-SQL)

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

Topic link iconTransact-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)

Help and Information

Getting SQL Server 2005 Assistance