Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
sp_help_fulltext_catalog_components (Transact-SQL)

sp_help_fulltext_catalog_components (Transact-SQL)

 

Applies To: SQL Server 2014, SQL Server 2016 Preview

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

System_CAPS_noteNote

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


sp_help_fulltext_catalog_components

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.

Requires membership in the public role.

Community Additions

ADD
Show:
© 2015 Microsoft