Export (0) Print
Expand All

sp_help_fulltext_catalog_components

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

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.

This stored procedure is of particular importance when preparing for an upgrade (service pack, or component). Execute the stored procedure within a particular database, and use the output to determine whether a particular full-text catalog will be impacted by the upgrade.

Requires membership in the public role.

Community Additions

ADD
Show:
© 2014 Microsoft