Changes the status of entries in the text_events table and forces the reindexing of the modified columns.
sp_redo_text_events [from_date [,to_date]]
is the starting date and time in a date range of entries to be modified.
is the ending date and time in the specified date range of the entries to be modified.
sp_redo_text_events "01/05/98:17:00", "02/12/98:08:30"
Re-ndexes columns that were modified between January 5, 1998 at 5:00 p.m. and February 12, 1998 at 8:30 a.m.
Resets the status to “unprocessed” for all entries in the text_events table that currently have a status of “processed.” The Enhanced Full-Text Search engine is notified that a reindex operation is required.
Useful for synchronizing a text index after a recovery of the Verity collection from a backup. This procedure is run automatically during sp_text_load_index.
If you omit to_date, all entries between from_date and the current date with a status of “processed” are reset to “unprocessed.”
If you omit both from_date and to_date, all entries in the text_events table with a status of “processed” are reset to “un-processed.”
to_date cannot be specified without from_date.
You have not specified the full range.
Any user can execute sp_redo_text_events.
