sp-help-fulltext-catalog-components-transact-sql.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs
sp_help_fulltext_catalog_components (Transact-SQL)	Returns a list of all components used for all full-text catalogs in the current database.	markingmyname	maghan	randolphwest	05/14/2024	sql	system-objects	reference	sp_help_fulltext_catalog_components_TSQL sp_help_fulltext_catalog_components	sp_help_fulltext_catalog_components	TSQL

sp_help_fulltext_catalog_components (Transact-SQL)

[!INCLUDE 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

[!INCLUDE ssNoteDepFutureAvoid]

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: 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