Full-Text Server Properties (Transact-SQL)

Transact-SQL functions can be used to obtain the value of various server-level properties of full-text search. This information is useful for administrating and troubleshooting full-text search.

The following table lists full-text properties of a SQL Server server instance that are useful in SQL Server 2008 and their related Transact-SQL functions.

Note

Only full-text properties that are useful in SQL Server 2008 are discussed here.

Property

Description

Function

IsFullTextInstalled

Whether the full-text component is installed with the current instance of SQL Server.

LoadOSResources

Whether operating system word breakers and filters are registered and used with this instance of SQL Server.

FULLTEXTSERVICEPROPERTY

VerifySignature

Specifies whether only signed binaries are loaded by the the Full-Text Engine.

FULLTEXTSERVICEPROPERTY