sp_refresh_text_index

Description

Records modifications in the text_events table when you change the text index’s source table data.

Syntax

sp_refresh_text_index table_name, column_name, rowid, mod_type

Parameters

table_name

– is the name of the source table being updated. table_name has the form [dbname.[owner.]]table, where:

column_name

– is the name of the column being updated.

rowid

– is the IDENTITY column value of the changed row.

mod_type

– specifies the type of the change. Must be insert, update, or delete.

Examples

Example 1

sp_refresh_text_index "blurbs", "copy", 2.000000, "update"

Records in the text_events table that you have updated the copy column of the blurbs table. The row you have updated has an id of 2.000000.

Usage

Messages

Permissions

Any user can execute sp_refresh_text_index.

See also

sp_text_notify