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
-
Expand the server group, expand Databases, and expand the database that contains the table you want to enable for full-text indexing.
-
Expand Tables, and right-click the table that you want to disable or re-enable for full-text indexing.
-
Select Full-Text index, and then click Disable Full-Text index or Enable Full-Text index.
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