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 |
See Also