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.

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

Topic link icon 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