| description | sp_help_fulltext_catalogs (Transact-SQL) | ||
|---|---|---|---|
| title | sp_help_fulltext_catalogs (Transact-SQL) | Microsoft Docs | ||
| ms.custom | |||
| ms.date | 03/14/2017 | ||
| ms.prod | sql | ||
| ms.prod_service | database-engine | ||
| ms.reviewer | |||
| ms.technology | system-objects | ||
| ms.topic | reference | ||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 1b94f280-e095-423f-88bc-988c9349d44c | ||
| author | markingmyname | ||
| ms.author | maghan |
[!INCLUDE SQL Server]
Returns the ID, name, root directory, status, and number of full-text indexed tables for the specified full-text catalog.
Important
[!INCLUDEssNoteDepFutureAvoid] Use the sys.fulltext_catalogs catalog view instead.
Transact-SQL Syntax Conventions
sp_help_fulltext_catalogs [ @fulltext_catalog_name = ] 'fulltext_catalog_name'
[ @fulltext_catalog_name = ] 'fulltext_catalog_name'
Is the name of the full-text catalog. fulltext_catalog_name is sysname. If this parameter is omitted or has the value NULL, information about all full-text catalogs associated with the current database is returned.
0 (success) or (1) failure
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 [!INCLUDEssKatmai], 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. |
Execute permissions default to members of the public role.
The following example returns information about the Cat_Desc full-text catalog.
USE AdventureWorks2012;
GO
EXEC sp_help_fulltext_catalogs 'Cat_Desc' ;
GO
FULLTEXTCATALOGPROPERTY (Transact-SQL)
sp_fulltext_catalog (Transact-SQL)
sp_help_fulltext_catalogs_cursor (Transact-SQL)
System Stored Procedures (Transact-SQL)