1.5. Creating the Microsoft SQL Server 2000 Full Text Index
HelpSpot requires full text indexes on 3 different tables. This guide will show you how to add these indexes through Enterprise Manager. The tables and fields are as follows:
- HS_Forums_Posts on field tPost (we'll use this as our example)
- HS_KB_Pages on field tPage
- HS_Request_History on field tNote
This example will go through adding the full text index on HS_Forums_Posts. You can then repeat these steps for the other two tables.
1. Open Enterprise Manager and connect to the database where you have installed HelpSpot. Navigate to the tables:
2. Right click on the table HS_Forums_Posts and select "define a full-text index on a table":
3. The wizard will open, click next:
4. When asked to pick the unique index the default is correct:
5. Select the field to full text index, tPost:
6. If you don't have a full text catalog already you'll need to create a new one:
7. Leave the "create population schedules" step empty:
7. Click finish to build the index:
8. To ensure updates are added to the index as they occur you need to enable "change tracking":
9. And finally, tell the database to update the index in the background:
Remember to perform these same steps on the other two tables. After you have completed these steps HelpSpot will be ready for use.
If you had already started using HelpSpot before performing these steps you should run the "full population" as well. That can be done by right clicking on the table, scrollig over full text index and selecting "start full population"