Returns information related to the properties of the Full-Text Engine. These properties can be set and retrieved by using sp_fulltext_service.
Applies to: SQL Server (SQL Server 2008 through current version).
The following example checks whether only signed binaries are loaded, and the return value indicates that this verification is not occurring.
Here is the result set.
Note that to set signature verification back to its default value, 1, you can use the following sp_fulltext_service statement:
EXEC sp_fulltext_service @action='verify_signature', @value=1; GO