FULLTEXTCATALOGPROPERTY (T-SQL)

Returns information about full-text catalog properties.

Syntaxt

FULLTEXTCATALOGPROPERTY(catalog_name, property)

Arguments

catalog_name

Is an expression containing the name of the full-text catalog.

property

Is an expression containing the name of the full-text catalog property. The table lists the properties and provides descriptions of the information that is returned.

Property	Description
PopulateStatus	0 = Idle 1 = Population in progress 2 = Paused 3 = Throttled 4 = Recovering 5 = Shutdown 6 = Incremental population in progress 7 = Updating index
ItemCount	Number of full-text indexed items currently in the full-text catalog.
IndexSize	Size of the full-text index in megabytes.
UniqueKeyCount	Number of unique words (keys) that make up the full-text index in this catalog. This is an approximation of the number of nonnoise words stored in the full-text catalog.
LogSize	Size, in bytes, of the combined set of error logs associated with a Microsoft Search Service full-text catalog.
PopulateCompletionAge	The difference in seconds between the completion of the last full-text index population and 01/01/1990 00:00:00.

Return Types

int

Remarks

It is important that applications do not wait in a tight loop, checking for the PopulateStatus property to become idle (indicating that population has completed) because this takes CPU cycles away from the database and full-text search processes and causes time outs.

Examples

This example returns the number of full-text indexed items in the Cat_Desc full-text catalog.

USE Northwind

GO

SELECT fulltextcatalogproperty('Cat_Desc', 'ItemCount')

Here is the result set:

-----------

9