Home > SQL Server > Retrieve Full-Text Search service property information – SQL Server 2012

Retrieve Full-Text Search service property information – SQL Server 2012


Full-Text Search : This is an additional component given in the SQL Server engine. We have to install and setup this environment to use this feature for any business. Full-Text Search allows a business to search a text pattern stored in the database columns such as char, varchar, nchar, nvarchar, text, ntext, image, xml, or varbinary(max) and FILESTREAM. But, We have to create full-text index for the columns that are participated in the full-text search. These indexes contain one or more columns from the table, and each column in the table can use a specific language as specific in the database design.

In this blog post, I am going to use a built-in function to retrieve the Full-Text Search service property information.

FULLTEXTSERVICEPROPERTY() : This function returns the full-text search engine property information.

Function Syntax

FULLTEXTSERVICEPROPERTY (‘property’)

Valid property names that can be used in this function are

pic1Query execution

select Fulltextserviceproperty(‘ConnectTimeout’) as ‘Connect Timeout’

select IIF(Fulltextserviceproperty(‘IsFulltextInstalled’)=1, ‘Full-text is installed’, ‘Full-text is not installed’)
as ‘Is Fulltext Installed?’

pic2

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: