FULLTEXTSERVICEPROPERTY
statements #tsql#statements
Syntax
FULLTEXTSERVICEPROPERTY ( 'property' )Return Type
int
Property Descriptions
| Property | Return Type | Description |
|---|---|---|
| ResourceUsage | int | Resource usage for full-text indexing. |
| ConnectTimeout | int | Connection timeout for full-text service. |
| DataTimeout | int | Data timeout for full-text service. |
Remarks
Returns information about Full-Text Search service-level properties.
Example
SELECT FULLTEXTSERVICEPROPERTY('database_name', 'ResourceUsage') AS ResourceUsage;