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