FULLTEXTSERVICEPROPERTY
Returns information related to the properties of the Full-Text Engine.
Syntax
FULLTEXTSERVICEPROPERTY ('property')
Arguments
'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 | Returns 0. |
| ConnectTimeout | Returns 0. |
| IsFulltextInstalled | 0 = Full-text is not installed. |
| LoadOSResources | Indicates whether operating system word breakers and filters are registered and used. By default, this property is disabled to prevent inadvertent behavior changes by updates made to the operating system (OS). |
| 0 = Use only filters and word breakers specific to this instance of Lyftron. | |
| VerifySignature | Specifies whether only signed binaries are loaded by the Microsoft Search Service. |
| 0 = Do not verify whether or not binaries are signed. |
Return types
int
Example
SELECT FULLTEXTSERVICEPROPERTY('VerifySignature');