sp_help_fulltext_catalogs (Transact-SQL)

Applies to: SQL Server

Returns the ID, name, root directory, status, and number of full-text indexed tables for the specified full-text catalog.


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. Use the sys.fulltext_catalogs catalog view instead.

Transact-SQL syntax conventions


sp_help_fulltext_catalogs [ [ @fulltext_catalog_name = ] N'fulltext_catalog_name' ]
[ ; ]


[ @fulltext_catalog_name = ] N'fulltext_catalog_name'

The name of the full-text catalog. @fulltext_catalog_name is sysname, with a default of NULL. If this parameter is omitted or has the value NULL, information about all full-text catalogs associated with the current database is returned.

Return code values

0 (success) or 1 (failure).

Result set

This table shows the result set, which is ordered by fulltext_catalog_id.

Column name Data type Description
fulltext_catalog_id smallint Full-text catalog identifier.
NAME sysname Name of the full-text catalog.
PATH nvarchar(260) 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 doesn't have VIEW permission on the full-text catalog, or database isn't 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 AdventureWorks2022;
EXEC sp_help_fulltext_catalogs 'Cat_Desc';