Export (0) Print
Expand All

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.

NoteNote

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft