sp_create_text_index

Description

Creates a text index.

Syntax

sp_create_text_index server_name, index_table_name, 
     table_name, “batch”, column_name
     [, column_name ... ]

Parameters

server_name

– is the name of the Full-Text Search engine.

index_table_name

– is the name of the index table. index_table_name has the form [dbname.[owner.]]table, where:

table_name

– is the name of the source table containing the text being indexed. table_name has the form [dbname.[owner.]]table.

batch

– The “batch” operator (must be in quotes) tells the Full-Text Search to reallocate every session after each batch sent to the VDK.

column_name

– is the name of the column indexed by the text index.

Examples

Example 1

sp_create_text_index "blue", "i_blurbs", "blurbs", " ", "copy"

Creates a text index and an index table named i_blurbs on the copy column of the blurbs table.

Usage

Messages

Permissions

Any user can execute sp_create_text_index.