O'Reilly logo

Guru's Guide to SQL Server Architecture and Internals, The by Ken Henderson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Setting Up Full-Text Indexes

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.

1.
Full-text indexing must be enabled in the host database.
2.
Full-text catalogs must be created for the database.
3.
Full-text indexing must then be enabled for the host table and associated with a full-text catalog.
4.
The column is then added to the table's full-text index.
5.
This full-text index is then activated.
6.
The full-text catalog must then be ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required