Syntax of FULLTEXTCATALOGPROPERTY Function :
FULLTEXTCATALOGPROPERTY ( catalog_name , property )
catalog_name is a name of the full-text catalog.
property is a name of full-text catalog property. Below is the table containing properties, return value and description of it.
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 type of FULLTEXTCATALOGPROPERTY function is an integer.
Examples of FULLTEXTCATALOGPROPERTY Function :
Example 1 : Use of FULLTEXTCATALOGPROPERTY function in select clause
SELECT FULLTEXTCATALOGPROPERTY('Cat_Desc','ItemCount')
Output
10
Above example returns number of items in the Cat_Desc catalog.