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.

System_CAPS_ICON_note.jpg Note

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

Topic link icon Transact-SQL Syntax Conventions


Column nameData typeDescription
full-text catalog nameintName of the full-text catalog.
full-text catalog idsysnameID of the full-text catalog.
componenttypesysnameType of component. One of the following:


Protocol handler

componentnamesysnameName of the component.
clsiduniqueidentifierClass identifier of the component.
fullpathnvarchar(256)Path to the location of the component.

NULL = Caller not a member of serveradmin fixed server role.
versionnvarchar(30)Version of the component.
manufacturersysnameName of the manufacturer of the component.

Requires membership in the public role.

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

Community Additions