How to: Disable or Re-enable a Table for Full-Text Indexing (SQL Server Management Studio)

In SQL Server 2008, all user-created databases are full-text enabled by default. Additionally, an individual table is automatically enabled for full-text indexing as soon as a full-text index is created on it and a column is added to the index. A table is automatically disabled for full-text indexing when the last column is dropped from its full-text index.

On a table that has a full-text index, you can manually disable or re-enable a table for full-text indexing using SQL Server Management Studio.

To enable a table for full-text indexing

  1. Expand the server group, expand Databases, and expand the database that contains the table you want to enable for full-text indexing.

  2. Expand Tables, and right-click the table that you want to disable or re-enable for full-text indexing.

  3. Select Full-Text index, and then click Disable Full-Text index or Enable Full-Text index.