• [アーティクル]

FullTextPopulation Method

この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。新しい開発作業では、この機能の使用を避け、現在この機能を使用しているアプリケーションは修正するようにしてください。

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 .

構文

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.

説明

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.

注意注

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

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:

Table2 Object