Each database containing tables referenced by a text index must contain a text_events table, which logs inserts, updates, and deletes to indexed columns. It is used to propagate updated data to the Verity collections.
Run the installevent script, as described below, to create the text_events table and associated system procedures in a database. Use the installevent script as follows:
If all databases require text indexes, run the installevent script to create a text_events table in the model database. Each newly created database will then have a text_events table. To add a text_events table to existing databases, edit the script as described below to create the text_events table in the existing user database.
If not all databases have text indexes, use the installevent script as a sample. For each existing database and each new database that includes tables that require text indexing, run the installevent script. You must edit the script as described below, to create the text_events table in the correct user database.
If a text_events table
does not exist in a database that includes source tables that require
text indexing, changes to the source table are not propagated to
the Verity collections.
