Changes the status of entries in the text_events table and forces the re-indexing 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-indexes 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 Full-Text Search engine is notified that a re-index operation is required.
Useful for synchronizing a text index after a recovery of the Verity collection from a backup. When you use the Enhanced Full-Text Search engine, this procedure is run automatically during sp_text_load_index.
If to_date is omitted, all entries between from_date and the current date with a status of “processed” are reset to “unprocessed.”
If both from_date and to_date are omitted, 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.