sp_text_kill

Description

Terminates all connections to a specific text index.

Syntax

sp_text_kill index_table_name

Parameters

index_table_name

is the name of the text index from which all connections are terminated. index_table_name has the form [dbname.[owner.]]table, where:

Examples

Example 1

sp_text_kill "i_blurbs"

Terminates all existing connections to the text index i_blurbs.

Usage

Messages

Permissions

Only user “sa” can execute sp_text_kill.

See also

sp_drop_text_index