SQL Server 2005 How to Enable the Full Text Catalog

Open the SQL Server Management Studio

      

Provide the appropriate info in the Connect to Server

 

Expand the Databases, Expand cBizOne (Currently it is Test1), Expand Storage and Expand the Full Text Catalogs.

Right click on the CBizOneCatalog and Rebuild

 

Click Ok

 

Click on Close

 

Right click on the CBizOneCatalog and click on Properties.

 

Click on the Tables/Views

Select the Consultants

 

Automatic	The full-text index is automatically updated when the data in the underlying table is modified, added, or deleted.
Manual	When data is modified, added, or deleted in the indexed data, SQL Server tracks the changes. When Manual change tracking is in effect, the index is not automatically updated with these changes. Instead, an administrator can apply the changes manually by using an ALTER FULLTEXT INDEX ... START UPDATE POPULATION statement.
Do not track change	With this option in effect, changes to the indexed data in the catalog are not recorded. An administrator must build the index by using ALTER FULLTEXT INDEX with either FULL POPULATION or INCREMENTAL POPULATION.

 

Check uuResumeText is checked and in the Track changes: select Do not track changes Radio button.

Attention: Track change "Automatic" is not suggested for large database.

 

Select the Population Schedule

 

Please click on the New, if it is already there then click on Edit.

 

Please provide the following information in the window and click OK.

 

In the SQL Server Management Studio expand the SQL Server Agent and right click on the newly created catalog JOB and run Start Job at Step…

Now Click On Close.

 

It’s done now close the SQL Server Management Studio and go to the client machine and open the cBiz and click on the Advanced Find…