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