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