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

title	sp_help_fulltext_catalog_components (Transact-SQL)
description	Returns a list of all components used for all full-text catalogs in the current database.
author	markingmyname
ms.author	maghan
ms.reviewer	randolphwest
ms.date	06/23/2025
ms.service	sql
ms.subservice	system-objects
ms.topic	reference
f1_keywords	sp_help_fulltext_catalog_components_TSQL sp_help_fulltext_catalog_components
helpviewer_keywords	sp_help_fulltext_catalog_components
dev_langs	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