Artigo
04/01/2012

FullTextPopulation Method

Esse recurso será removido em uma versão futura do Microsoft SQL Server. Evite usar esse recurso em desenvolvimentos novos e planeje modificar os aplicativos que atualmente o utilizam.

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 .

Sintaxe

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.

Comentários

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.

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

Observação
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.