Chapter 2: Understanding the Enhanced Full-Text Search Engine

The text_events table

Each database containing tables for which there is a text index must contain an events table, which logs inserts, updates, and deletes to indexed columns. The name of this table is text_events. It is used to propagate updated data to the Verity collections.

The columns in the text_events table are described in Table 2-3.

**Table 2-3: Columns in the *text_events* table**
Column name	Description
event_id	IDENTITY column
id	ID of the row that was updated, inserted, or deleted
tableid	Name of the table that contains the row that was updated, inserted, or deleted
columnid	Name of the column on which the text index was created
event_date	Date and time of the update, insert, or delete
event_type	Type of update (update, insert, or delete)
event_status	Indicates whether the update, insert, or delete has been propagated to the collections. 0 – Event Unread 1 – Event Read 2 – Event Succeeded 3 – Event Failed
srvid	Server ID of the Enhanced Full-Text Search engine maintaining the collection

View this book as PDF