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