sp_help_fulltext_catalog_components (Transact-SQL)
Returns a list of all components (filters, word-breakers, and protocol handlers), used for all full-text catalogs in the current database.
[!UWAGA]
This feature will be removed in a future version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.
.gif "Ikona łącza do tematu")
Transact-SQL Syntax Conventions
Składnia
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:
|
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.
Zobacz także
Odwołanie
Full-Text Search and Semantic Search Stored Procedures (Transact-SQL)
sys.fulltext_catalogs (Transact-SQL)
sp_help_fulltext_system_components (Transact-SQL)