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 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.
None
Any user can execute sp_clean_text_events.
