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

title	sp_help_fulltext_catalog_components (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sp_help_fulltext_catalog_components_TSQL sp_help_fulltext_catalog_components
dev_langs	TSQL
helpviewer_keywords	sp_help_fulltext_catalog_components
ms.assetid	fbd6a3d4-6a4c-42a2-bff8-2a5eb0745e47
author	MikeRayMSFT
ms.author	mikeray

sp_help_fulltext_catalog_components (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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

Note

[!INCLUDEssNoteDepFutureDontUse]

Transact-SQL Syntax Conventions

Syntax

  
sp_help_fulltext_catalog_components  

Result Sets

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: 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.

See Also

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