===== Installing Index Server =====

<color red>Please be aware that MS fix KB2698365 will stop the indexing server working.  Tests show it is OK but when searching you will receive an error “Unable to execute text search” Remove this item from Windows and the search will continue to work.</color>

**Configure Index Server (W2K)**

Access indexing server through computer management/services and applications /indexing service / system/directories.  Create a new directory (Right click and select new)  Name the folder PersonCV.  Set priority to Instant and low load.  Start service.

**Document folder**

Create folder for docs to be indexed in root of a drive other than the one used by DB, call it CVTEXT.    Once the file is created create a TXT document inside and enter some words.  Close and save.

**Daemon**

Install Daemon.exe on the route of drive, either Ntserver or Windows 2000/XP version.  Run testbed.exe, then login with the DB name. Select OK ignoring search definition.  Enter the following details:

ID:		PersonCV
Catalog:	System
Scope:		
Directory:	C:\CVText
Command:	(directory path of Daemon.exe) C:\winnt\iqxsdbDaemon5.exe
DSN:		(DSN Name of IQX DB entry usually IQX)
UID:		Pears

Now enter text contained in the saved text file into the Query field and run the query.

**SQL Script**

Login to the DB using SQLTool or ISQL.  Run script.  A typical trigger is below:

<code SQL>
create trigger pears.PersonCVUpdate AFTER update of CvText
order 2 on pears.Person
referencing OLD as Old_Name NEW as New_Name
for each row
begin
  call IXTextWrite('PersonCV','CV',old_name.PersonID,new_name.CVText)
end
</code>

**Pears Dictionary**

Login to DB using SQLTool
Go to dictionary
Select People and CV
Change the following:
Type:			Indexed Text
Database Item:		PersonCV
Complex Expression:	Person.PersonID in (<EXPRESSION>)