Rediģēt

Kopīgot, izmantojot

sp_help_fulltext_catalog_components (Transact-SQL)

  • Raksts

Applies to: SQL Server

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 SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

Transact-SQL syntax conventions

Syntax

sp_help_fulltext_catalog_components
[ ; ]

Arguments

None.

Result set

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 values:

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.

Related content