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.

 See Also

Tasks

How to: Create a Full-Text Catalog (SQL Server Management Studio)
How to: Start the Full-Text Indexing Wizard (SQL Server Management Studio)
How to: Remove a Full-Text Index from a Table (SQL Server Management Studio)

Concepts

Full-Text Search Overview

Other Resources

CREATE FULLTEXT CATALOG (Transact-SQL)
CREATE FULLTEXT INDEX (Transact-SQL)
DROP FULLTEXT INDEX (Transact-SQL)
CREATE FULLTEXT INDEX (Transact-SQL)
ALTER FULLTEXT INDEX (Transact-SQL)

Help and Information

Getting SQL Server 2008 Assistance