• Article

sp_help_fulltext_catalog_components (Transact-SQL)

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.

Topic link iconTransact-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.