Knowledgebase Search: 3 letter term in search, no results are being returned

In order to allow three character searches in the knowledgebase please carry out the following:

Access the Supportworks Server

1..Stop All Services from the services console: services.msc

2..Edit the following file C:\Program Files\Hornbill\Core Services\SwSQLServer\Bin\SwSQL.ini (where C: = drive you have installed supportworks server on)

3..Add the following parameter and Save the changes

set-variable = ft_min_word_len=3

4..Restart Only the SwSQLServer

5..Run the SupportWorks Interactive SQL Program (Start->Programs->Hornbill Core Services->Interactive SQL)

6..Enter the following SQL

Use sw_knowledgebase;
Alter Table KbDocuments Drop Index Title;
ALTER TABLE kbdocuments ADD FULLTEXT (Title,Keywords,Problem,Solution,CallProbCode);

7..Thereafter restart the SwSql server service and all remaining services.