To enable a database for full text indexing Sql server 2005

To enable a database for full text indexing Sql server 2005

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

---

1. In Object Explorer, expand the server group, right-click the database for which you want to enable full-text indexing, and then select Properties.
2. Select the Files page, and then select Use full-text indexing.

visit link download