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.

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