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.
Valid property names that can be used in this function are
select Fulltextserviceproperty(‘ConnectTimeout’) as ‘Connect Timeout’
select IIF(Fulltextserviceproperty(‘IsFulltextInstalled’)=1, ‘Full-text is installed’, ‘Full-text is not installed’)
as ‘Is Fulltext Installed?’