Removes processed entries from the text_events table.
– the date and time through which all processed entries will be deleted.
Removes data entered on or before January 15, 1998 at 5:00 p.m.
If the up_to_date parameter is specified, all entries having a date less than or equal to up_to_date and whose status is set to processed is deleted.
If up_to_date is omitted, 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.
With the Enhanced Full-Text Search engine, the sp_text_dump_database system procedure automatically runs this.
Any user can execute sp_clean_text_events.