FULLTEXTSERVICEPROPERTY (T-SQL)

Returns information about full-text service-level properties.

Syntaxt

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 that is 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	1 = Microsoft Search (Full-text) Service is installed on the computer. 0 = Otherwise.

Return Types

int

Examples

This example verifies that Microsoft Search Service is installed.

SELECT fulltextserviceproperty('IsFulltextInstalled')

Here is the result set:

-----------

1

See Also