SQL Server Full Text Indexes

In SQL Server 2008, all databases are full-text enabled.

You then create a full-text index on a table from SQL Server Management Studio: click on a table, and then right click and select Full-Text index. Note, you must already have a primary key on the table before you can create a full-text index.

The full-text index is updated/populated on a schedule as updates happen. You can configure the schedule to be recurring at times you specify. There are 2 schedules:

1) A schedule for the catalog as a whole

2) Optionally, a separate schedule for a single table