Export (0) Print
Expand All

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.

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

Show:
© 2015 Microsoft