sp_help_fulltext_catalog_components (Transact-SQL)
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
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru