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

Remarks

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.

Permissions

Requires membership in the public role.

See Also

Reference

Full-Text Search Stored Procedures (Transact-SQL)
sys.fulltext_catalogs (Transact-SQL)
sp_help_fulltext_system_components (Transact-SQL)

Other Resources

Full-Text Search

Help and Information

Getting SQL Server 2005 Assistance