Setting up Full-Text search

You can find records that contain specified text anywhere in the database by using a Full-Text Search. Full-Text Search requires an SQL Server database, which must be provided by a server that is running Microsoft™ SQL Server with the Microsoft Search service.

To provide Full-Text Searching within a database, you must:

Define how to create the index.
Create the index.
Set up rebuilding or updating of the index at appropriate times.

Full-Text Search works in collaboration with SQL Server but it is separate from SQL Server and is installed only as part of a custom installation.

The Microsoft Search service is used to search, catalog, and index the database. This service maintains catalogs and indexes outside SQL Server, on the server computer’s file system.