sp_help_fulltext_catalog_components (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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


This feature will be removed in a future version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

|Applies to: SQL Server ( SQL Server 2008 through current version), SQL Database.|

Topic link icon Transact-SQL Syntax Conventions



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:


Protocol handler

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.


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