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:

dbname is the name of the database containing the table.

owner is the name of the owner of the table.

table is the name of the table.

column_name: is the name of the column being updated.

rowid: is the IDENTITY or primary key column value of the changed row.

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

Examples

Example 1

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:

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

Usage

The user maintains the consistency of the text index. You must run sp_refresh_text_index anytime you update source data that has been indexed so that the text_events table reflects the change. This keeps the collections in sync with your source data. The collections are not updated until you run sp_text_notify.

You can create triggers that issue sp_refresh_text_index for non-text and non-image columns. See “Propagating changes to the text index”.

Messages

Column ‘column_name’ does not exist in table ‘table_name.’
Invalid mod_type specified (‘mod_type’). Correct values: INSERT, UPDATE, DELETE.
Owner ‘owner_name’ does not exist.
Table ‘table_name’ does not exist.
‘table_name’ is not a valid name.
Text event table not found.

Permissions

Any user can execute sp_refresh_text_index.