Setting up full-text indexes is not a one-step process. With increased flexibility often comes increased complexity. Assuming the Microsoft Search service is started, the process required to set up a specific table column so that it can be searched with full-text search syntax such as the CONTAINS predicate and the FREETEXTTABLE rowset function includes six steps.
Full-text indexing must be enabled in the host database.
Full-text catalogs must be created for the database.
Full-text indexing must then be enabled for the host table and associated with a full-text catalog.
The column is then added to the table's full-text index.
This full-text index is then activated.
The full-text catalog must then be ...