Syntax of FULLTEXTSERVICEPROPERTY Function :
FULLTEXTSERVICEPROPERTY ( property )
property is a name of full-text service-level property. Below is the table containing properties, return value and description of it.
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 SQL Serverdatabase 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 type of FULLTEXTSERVICEPROPERTY function is an integer.
Examples of FULLTEXTSERVICEPROPERTY Function :
Example 1 : Use of FULLTEXTSERVICEPROPERTY function in select clause
SELECT FULLTEXTSERVICEPROPERTY( 'IsFulltextInstalled' )
Output
1
Above example returns value 1 for property IsFulltextInstalled property that means full text search is installed.