The source tables in the user database must 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.
