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.
0 = Full-text is not installed.
NULL = Invalid input, or error.

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

See Also

FULLTEXTCATALOGPROPERTY

Metadata Functions

sp_fulltext_service