Returns information about full-text catalog properties.
FULLTEXTCATALOGPROPERTY ( catalog_name , property )
Is an expression containing the name of the full-text catalog.
Is an expression containing the name of the full-text catalog property. The table lists the properties and provides descriptions of the information returned.
|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.|
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.
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: