(Enhanced version only)
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 will be 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.
sp_text_kill "i_blurbs"
Terminates all existing connections to the text index i_blurbs.
sp_text_kill is available only with Enhanced Full-Text Search Specialty Data Store.
This system procedure causes the 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.
