Compartir a través de


TableFullTextChangeTrackingOn Property

Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.

The TableFullTextChangeTrackingOn property specifies whether to enable the tracking and propagation of changes to a table for a full-text image index.

Sintaxis

object
.TableFullTextChangeTrackingOn [= value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list
  • value
    TRUE or FALSE

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetTableFullTextChangeTrackingOn(LPBOOL pRetVal);
HRESULT SetTableFullTextChangeTrackingOn(BOOL NewValue);

Notas

If set to TRUE, the TableFullTextChangeTrackingOn property begins an incremental tracking of changes to a full-text search index if the table has a timestamp column to support the full-text tracking process. If set to FALSE, TableFullTextChangeTrackingOn stops tracking changes to the table.

Set TableFullTextChangeTrackingOn to TRUE to enable the tracking and propagation of changes to a table for a full-text image index referenced by the Microsoft Search service. TableFullTextChangeTrackingOn must be set to TRUE before an application can set the TableFullTextUpdateIndexOn property or call the FullTextUpdateIndex method to propagate the changes.

Changes can be propagated to the index:

  • On a scheduled basis, using SQL Server Agent.

  • As they occur, using the TableFullTextUpdateIndexOn property.

  • On demand, using the FullTextUpdateIndex method.

    [!NOTA] Prior to setting TableFullTextChangeTrackingOn, add the catalog to the FullTextCatalogsCollection, and set IsFullTextEnabled to TRUE for the database.

    If an application calls TableFullTextChangeTrackingOn 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

Vea también

Referencia

FullTextPopulateStatus Property
FullTextPopulation Method
FullTextUpdateIndex Method
TableFullTextUpdateIndexOn Property

Ayuda e información

Obtener ayuda sobre SQL Server 2005