.png)
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 |
