Use FullTextServiceProperty to determine if full-text service is installed

Recently I need to determine whether full-text search functionality is installed and enabled on a Microsoft SQL Server 2005 instance. I later discovered that the T-SQL function FullTextServiceProperty can be used to determined if Full-Text search is installed or not on a SQL Server instance.

FullTextServiceProperty is a T-SQL function which return information about full-text service installed on the related Microsoft SQL Server instance. You can use FullTextServiceProperty t-sql function especially to check whether fulltext search component is installed on the current SQL Server instance and get the status of the full-text service.

FullTextServiceProperty function uses the property name as an input parameter. You can find the FullTextServiceProperty function syntax below:

FULLTEXTSERVICEPROPERTY('property')

And the available properties that can be used with fulltextserviceproperty function is as follows:

IsFullTextInstalled : If you pass this property as an input to the FullTextServiceProperty the returned value will be an indicator whether full-text component is installed on the related instance of Microsoft SQL Server instance.

Possible return values are 1, 0 and NULL values.

If FullTextServiceProperty function combined with IsFullTextInstalled parameter returns 1, this indicated that Full-text is installed. If return value is 0 then full-text service is not installed on the SQL Server.

ResourceUsage : If ResourceUsage is used as an input parameter for the FullTextServiceProperty, the returned value will be an indicator how the Microsoft Search Service is using system memory for full-text indexing. The return value is an integer between 1 and 5 where 5 indicated that the system memory is heavily used for full-text indexing process.

BlinkList   Del.icio.us   Digg   Furl   Simpy   Spurl   DZone   ma.gnolia   Shadows