Terminates all connections to a specific text index.
sp_text_kill 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:
dbname is the name of the database containing the index table. If present, the owner or a placeholder is required.
owner is the name of the owner of the index table.
table is the name of the index table.
Terminates all existing connections to the text index i_blurbs:
sp_text_kill "i_blurbs"
This system procedure causes the Enhanced Full-Text Search engine to terminate all connections to the specified index, except for the connection that initiated the request.
Attempts to drop a text index that is currently in use will fail. sp_text_kill can be used to terminate all existing connections so that the index can be successfully dropped.
Index ‘index_table_name’ is not a text index.
This procedure is not supported against remote server ‘server_name.’
‘index_table_name’ does not exist.
Only the System Administrator (SA) may execute this procedure.
Only user “sa” can execute sp_text_kill.
