Share via


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 new sys.fulltext_catalogs catalog view instead. For more information, see sys.fulltext_catalogs.

Topic link iconTransact-SQL Syntax Conventions

Syntax

sp_help_fulltext_catalogs [ @fulltext_catalog_name = ] 'fulltext_catalog_name'

Arguments

  • [ @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.

Return Code Values

0 (success) or (1) failure

Result Sets

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)

Complete path to the physical location of the full-text catalog file. NULL indicates the default directory determined during installation. (This is the Ftdata subdirectory under the Microsoft SQL Server directory; for example, C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData.)

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.

Permissions

Execute permissions default to members of the public role.

Examples

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

USE AdventureWorks;
GO
EXEC sp_help_fulltext_catalogs 'Cat_Desc' ;
GO

See Also

Reference

FULLTEXTCATALOGPROPERTY (Transact-SQL)
sp_fulltext_catalog (Transact-SQL)
sp_help_fulltext_catalogs_cursor (Transact-SQL)
System Stored Procedures (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance