Export (0) Print
Expand All
Expand Minimize

FULLTEXTSERVICEPROPERTY (Transact-SQL)

Returns information about full-text service-level properties. Full-Text Search services are provided by Microsoft SQL Server (MSSQLSERVER) and the Microsoft Search Service (MSFTESQL) services. These properties may be set and retrieved using sp_fulltext_service.

Topic link icon Transact-SQL Syntax Conventions


FULLTEXTSERVICEPROPERTY ('property')

property

Is an expression containing the name of the full-text service-level property. The table lists the properties and provides descriptions of the information returned.

Property Value

ResourceUsage

Is a value from 1 (least aggressive) through 5 (most aggressive) that determines how aggressively the Microsoft Search Service uses system memory for the full-text indexing process. The default is 3.

ConnectTimeout

Returns 0. Supported for backward compatibility only.

IsFulltextInstalled

The full-text component is installed with the current instance of SQL Server.

1 = Full-text is installed.

0 = Full-text is not installed.

NULL = Invalid input, or error.

DataTimeout

Returns 0. Supported for backward compatibility only.

LoadOSResources

Indicates whether or not operating system word breakers 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 (OS). Enabling use of OS resources provides access to resources for languages and document types registered with Microsoft Indexing Service, but 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 VerifySignature is set to 1.

1 = Load OS filters and word breakers.

0 = Use only filters and word breakers specific to this instance of SQL Server.

VerifySignature

Specifies whether or not only signed binaries are loaded by the Microsoft Search Service. By default, only trusted, signed binaries are loaded.

1 = Verify that only trusted, signed binaries are loaded.

0 = Do not verify whether or not binaries are signed.

The following example verifies that Microsoft Full-Text Engine for SQL Server (MSFTESQL) service is installed.

SELECT fulltextserviceproperty('IsFulltextInstalled')

Here is the result set.

----------- 
1
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft