sp_help_fulltext_catalog_components (Transact-SQL)

Applies to: SQL Server

Returns a list of all components (filters, word-breakers, and protocol handlers), used for all full-text catalogs in the current database.

Note

This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Transact-SQL syntax conventions

Syntax

sp_help_fulltext_catalog_components
[ ; ]

Arguments

None.

Result set

Column name	Data type	Description
full-text catalog name	int	Name of the full-text catalog.
full-text catalog id	sysname	ID of the full-text catalog.
componenttype	sysname	Type of component. One of the following values: Filter Protocol handler Wordbreaker
componentname	sysname	Name of the component.
clsid	uniqueidentifier	Class identifier of the component.
fullpath	nvarchar(256)	Path to the location of the component. NULL = Caller not a member of serveradmin fixed server role.
version	nvarchar(30)	Version of the component.
manufacturer	sysname	Name of the manufacturer of the component.

Permissions

Requires membership in the public role.

Related content

• Full-Text Search and Semantic Search stored procedures (Transact-SQL)
• sys.fulltext_catalogs (Transact-SQL)
• sp_help_fulltext_system_components (Transact-SQL)
• Full-Text Search