7 out of 19 rated this helpful - Rate this topic

How to: Enable a Table for Full-Text Indexing (SQL Server Management Studio)

SQL Server 2005

Updated: 12 December 2006

In SQL Server 2005, by default, all user-created databases are full-text enabled. 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.

You can manually disable or reenable a table for full-text indexing by using SQL Server Management Studio.

To enable a table for full-text indexing

Expand the server group, expand Databases, expand User Databases, and expand the database that contains the table you want to enable for full-text indexing.
Right-click the table that you want to enable for full-text indexing.
Select Full-Text index, and then click Enable Full-Text indexing.

Other Resources

ALTER FULLTEXT INDEX (Transact-SQL)
Full-Text Search Concepts

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD