Select Change Tracking (Full-Text Indexing Wizard)

To start the Full-Text Indexing Wizard

• How to: Start the Full-Text Indexing Wizard (SQL Server Management Studio)

Options

• Automatically
  Select this radio button to have the full-text index updated automatically as changes occur to the underlying data.

• Manually
  Select this radio button if you do not want the full-text index to be updated automatically as changes occur to the underlying data. Changes to the underlying data are maintained. However, to apply the changes to the full-text index you must start or schedule this process manually.

• Do not track changes
  Select this radio button if you do not want the full-text index to be updated with changes to the underlying data.

• Start full population when index is created
  Select this radio button to kick off a full population at the successful completion of this wizard. This will consist of creating the full-text index structure in the catalog and populating it with full-text indexed data.

See Also

Reference

CREATE FULLTEXT CATALOG (Transact-SQL)