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