Removes processed entries from the text_events table.
sp_clean_text_events [up_to_date]
the date and time through which all processed entries will be deleted.
sp_clean_text_events "01/15/98:17:00"
Removes data entered on or before January 15, 1998 at 5:00 p.m.
If you do not specify the up_to_date parameter, all entries having a date less than or equal to up_to_date and whose status are set to processed is deleted.
If you ommit up_to_date, all entries whose status is set to processed is deleted.
Remove entries from the text_events table only after you have backed up the collection associated with the text index.
sp_text_dump_database automatically runs.
None.
Any user can execute sp_clean_text_events.
