Transact-SQL Reference
FULLTEXTSERVICEPROPERTY
Returns information about full-text service-level properties.
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 | A value from 1 (background) through 5 (dedicated). |
| ConnectTimeout | The number of seconds that Microsoft Search Service will wait for all connections to the Microsoft® SQL Server™ database server for full-text index population before timing out. |
| IsFulltextInstalled | The full-text component is installed with the current instance of SQL Server.
1 = Full-text is installed. |
| DataTimeout | The number of seconds that Microsoft Search Service will wait for data to be returned by Microsoft SQL Server database server for full-text index population before timing out. |
Return Types
int
Examples
This example verifies that Microsoft® Search Service is installed.
SELECT fulltextserviceproperty('IsFulltextInstalled')
Here is the result set:
-----------
1