How to: Enable a Database for Full-Text Indexing (SQL Server Management Studio)
New: 14 April 2006
In Microsoft SQL Server 2005, by default, all user-created databases are full-text enabled. However, there may be situations in which full-text indexing has been disabled.
To enable a database for full-text indexing
In Object Explorer, expand the server group, right-click the database for which you want to enable full-text indexing, and then select Properties.
Select the Files page, and then select Use full-text indexing.
See Also
Tasks
How to: Enable a Table for Full-Text Indexing (SQL Server Management Studio)