title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | monikerRange | ||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
View or change registered filters & word breakers |
View the currently registered word breaker or filters, and register newly installed word breakers and filters. |
rwestMSFT |
randolphwest |
mikeray |
01/29/2024 |
sql |
search |
conceptual |
|
=azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current |
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance]
After any word breakers or filters are installed or uninstalled on a system, the changes don't automatically take effect on server instances. This article describes how to view the currently registered word breaker or filters and how to register newly installed word breakers and filters on an instance of [!INCLUDE ssNoVersion].
Note
[!INCLUDE ssazuremi-md] supports viewing registered filters and word breakers, but changing them is not supported. Only preinstalled ones can be used. Third party filters and word breakers are not supported on managed instance.
-
Use the sys.fulltext_languages catalog view, as follows:
SELECT * FROM sys.fulltext_languages;
-
Use the sp_help_fulltext_system_components system stored procedure, as follows:
EXEC sp_help_fulltext_system_components 'filter';
-
Use the sp_fulltext_service system stored procedure to update the list of languages, as follows:
EXEC sp_fulltext_service 'update_languages';
-
Use the
sp_fulltext_service
to update the list of languages, as follows:EXEC sp_fulltext_service 'update_languages';
-
Use the
sp_fulltext_service
to restart the filter daemon host processes (fdhost.exe), as follows:EXEC sp_fulltext_service 'restart_all_fdhosts';
-
When preparing to install a DLL file that contains new word breakers or filters, verify that it has a different filename from any of the existing DLL files installed on your server instance.
-
Copy the new DLL file into the directory containing the standard [!INCLUDE ssNoVersion] DLL files for the server instance. The default location is:
C:\Program Files\Microsoft SQL Server\MSSQL.<instance_name>\MSSQL\Binn
[!IMPORTANT]
We highly recommend that you load only signed and verified components. Also, we recommend that you run the FDHOST Launcher (MSSQLFDLauncher) Service with the least possible privileges. -
Install the new word breaker or filters.
To install and load Microsoft Filter Pack IFilters
-
Use
sp_fulltext_service
to load newly installed word breakers and filters in the server instance, as follows:EXEC sp_fulltext_service @action='load_os_resources', @value=1;
-
Use
sp_fulltext_service
to update the list of languages, as follows:EXEC sp_fulltext_service 'update_languages';
-
Restart the filter daemon host processes (
fdhost.exe
), usingsp_fulltext_service
as follows:EXEC sp_fulltext_service 'restart_all_fdhosts';