Step 4. Create the Text Index and Index Table

The source tables in the user database need to be indexed so that you can perform full-text searches. For example, to create a text index and an index table named reviews_idx for the plot column in the reviews table, enter:

sp_create_text_index "MYTXTSVR", "reviews_idx", "reviews", " ", "plot"

The reviews table is now available for running full-text searches.

See sp_create_text_index for more information.