FullTextPopulation Method
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The FullTextPopulation method starts or stops Microsoft Search full-text table population, building the index supporting full-text queries on data maintained by Microsoft SQL Server .
Syntax
object.FullTextPopulation(Type)
Parts
object
Expression that evaluates to an object in the Applies To list.Type
Long integer that specifies a SQLDMO_FULLTEXT_POPULATE_ TYPE constant as described in Settings.
Prototype (C/C++)
HRESULT FullTextPopulation(SQLDMO_FULLTEXT_POPULATE_TYPE NewType);
Settings
Set Type using these values.
Constant |
Value |
Description |
|---|---|---|
SQLDMOFullText_PopuFull |
0 |
Perform a full population of the of the table index to the full-text catalog. |
SQLDMOFullText_PopuInc |
1 |
Perform an incremental population of the table index to the full-text catalog. |
SQLDMOFullText_PopuStop |
2 |
Stop full or incremental population of the table index to the full-text catalog. |
Remarks
Setting the Type parameter to SQLDMOFullText_PopuFull results in a complete rebuild of the index. Setting Type to SQLDMOFullText_PopuInc causes FullTextPopulation to rescan the rows changed since the last full rebuild. The table must have a timestamp column to support the SQLDMOFullText_PopuInc setting.
Use the FullTextPopulateStatus property to determine the current status of the full-text table population process.
Note
Prior to setting FullTextTracking, you must add the catalog to the FullTextCatalogsCollection, and set IsFullTextEnabled to TRUE for the database.
Note
If an application calls FullTextPopulation on an instance of SQL Server version 7.0, the constant, SQLDMO_E_SQL80ONLY, and the message "This property or method requires Microsoft SQL Server 2000 or later" are returned.