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.

Ważne:
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.

Składnia

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

Execute permissions default to members of the public role.

The following example returns information about the Cat_Desc full-text catalog.

USE AdventureWorks;
GO
EXEC sp_help_fulltext_catalogs 'Cat_Desc' ;
GO