Appendix A: System Procedures

sp_check_text_index

Reports or fixes consistency problems in Enhanced Full-Text Search index and source tables.

sp_clean_text_events

Removes processed entries from the text_events table.

sp_clean_text_indexes

Removes text indexes that are not associated with a table.

sp_create_text_index

Creates an external text index.

sp_drop_text_index

Drops text indexes.

sp_help_text_index

Displays text indexes.

sp_optimize_text_index

Runs the Verity optimization routines.

sp_redo_text_events

Changes the status of entries in the text_events table and forces re-indexing of the modified table.

sp_refresh_text_index

Adds an entry to the text_events table reflecting updates to the corresponding source table.

sp_show_text_online

Displays information about databases or indexes that are currently online.

sp_text_cluster

Displays or modifies clustering options.

sp_text_configure

Displays or modifies Enhanced Full-Text Search engine configuration parameters.

sp_text_dump_database

Makes a backup copy of the text indexes in a database and optionally dumps the text_db and current databases.

sp_text_kill

Terminates all connections to a specific text index.

sp_text_load_index

Restores text indexes from a backup.

sp_text_notify

Notifies the Enhanced Full-Text Search engine that the text_events table has been modified.

sp_text_online

Makes a database available to Adaptive Server.