Logo 
Search:

SQL Server Articles

Submit Article
Home » Articles » SQL Server » Meta Data FunctionsRSS Feeds

FULLTEXTSERVICEPROPERTY Function

Posted By: Sarita Patel     Category: SQL Server     Views: 3044

This article explains about FULLTEXTSERVICEPROPERTY function in sql server with examples.

FULLTEXTSERVICEPROPERTY function returns information about full-text service-level properties.


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.
  
Share: 


Didn't find what you were looking for? Find more on FULLTEXTSERVICEPROPERTY Function Or get search suggestion and latest updates.

Sarita Patel
Sarita Patel author of FULLTEXTSERVICEPROPERTY Function is from United States.
 
View All Articles

Related Articles and Code:


 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!