FullTextPopulation Method

Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.

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 .

Syntaxe

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.

Notes

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.

[!REMARQUE]

Prior to setting FullTextTracking, you must add the catalog to the FullTextCatalogsCollection, and set IsFullTextEnabled to TRUE for the database.

[!REMARQUE]

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.

Applies To: