Returns information for the registered word-breakers, filter, and protocol handlers. sp_help_fulltext_system_components also returns a list of identifiers of databases and full-text catalogs that have used the specified component.
The following result set is returned for the system components.
Type of component. One of the following:
Name of the component.
Class identifier of the component.
Path to the location of the component.
NULL = Caller not a member of serveradmin fixed server role.
Version of the component.
Name of the manufacturer of the component.
The following result set is returned only if one or more than one full-text catalog exists that uses component_type.
ID of the database.
ID of the full-text catalog.
A. Listing all full-text system components
The following example lists all of the full-text system components that have been registered on the server instance.
EXEC sp_help_fulltext_system_components 'all'; GO
B. Listing word breakers
The following example lists all the word breakers registered on the service instance.
EXEC sp_help_fulltext_system_components 'wordbreaker'; GO
C. Determining whether a specific word breaker is registered
The following example will list the word breaker for the Turkish language (LCID = 1055) if it has been installed on the system and registered on the service instance. This example specifies the parameter names, @component_type and @param.
EXEC sp_help_fulltext_system_components @component_type = 'wordbreaker', @param = 1055; GO
By default, this word breaker is not installed, so the result set is empty.
D. Determining whether a specific filter has been registered
The following example lists the filter for the .xdoc component if it has been manually installed on the system and registered on the server instance.
EXEC sp_help_fulltext_system_components 'filter', '.xdoc'; GO
By default, this filter is not installed, so the result set is empty.
E. Listing a specific .dll file
The following example lists a specific .ddl file, nlhtml.dll, which is installed by default.
EXEC sp_help_fulltext_system_components 'fullpath', 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Binn\nlhtml.dll'; GO