FULLTEXTCATALOGPROPERTY

Transact-SQL Reference

Transact-SQL Reference

FULLTEXTCATALOGPROPERTY

Returns information about full-text catalog properties.

Syntax

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

Property Description
PopulateStatus 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
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

See Also

FULLTEXTSERVICEPROPERTY

Metadata Functions

sp_help_fulltext_catalogs