Each database containing tables referenced by a text index must contain a text_events table, which logs inserts, updates, and deletes to indexed columns.
If a text_events table is in your model database, it will be in all new databases. If a text_events table is not in your model database, run the installevent script to install the text_events table in the new database. For example, to install the text_events table in the movies database:
Save the installevent script as installeventmovies.
Edit the script to replace all references to the word model with the word movies.
Run the script as follows:
isql -Usa -P -SMYSVR -i $SYBASE/$SYBASE_FTS/scripts/installeventmovies
See “Running the installevent Script” for information on installing the text_events table.
