Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
See Also
Other Resources
ALTER FULLTEXT INDEX (Transact-SQL)
Full-Text Search Concepts