.png)
sp_help_fulltext_catalogs (Transact-SQL)
Returns the ID, name, root directory, status, and number of full-text indexed tables for the specified full-text catalog.
Important
|
|---|
|
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use the sys.fulltext_catalogs catalog view instead. |
This table shows the result set, which is ordered by ftcatid.
|
Column name |
Data type |
Description |
|---|---|---|
|
fulltext_catalog_id |
smallint |
Full-text catalog identifier. |
|
NAME |
sysname |
Name of the full-text catalog. |
|
PATH |
nvarchar(260) |
Beginning with SQL Server 2008, this clause has no effect. |
|
STATUS |
int |
Full-text index population status of the catalog: 0 = Idle 1 = Full population in progress 2 = Paused 3 = Throttled 4 = Recovering 5 = Shutdown 6 = Incremental population in progress 7 = Building index 8 = Disk is full. Paused 9 = Change tracking NULL = User does not have VIEW permission on the full-text catalog, or database is not full-text enabled, or full-text component not installed. |
|
NUMBER_FULLTEXT_TABLES |
int |
Number of full-text indexed tables associated with the catalog. |
