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.