SQL Server - Hi -Um, I tried the code you gave as an example:select * from FT_test where

Asked By Steve M

10-Nov-09 01:06 PM

Hi -

Um, I tried the code you gave as an example:

select * from FT_test where contains(theText, 'formsof(thesaurus, ''jog'')')

, and it did not return anything. Clean boot, waited after giving the
population command, no error messages ..

I just re-tried it on a new clean db and new catalog. Same result.

???




1) Thesaurus only works for freetext searches or formsof(thesaurus with
contains.
select * from FT_test where contains(theText, 'formsof(thesaurus, ''jog'')')

2) no.

10-Nov-09 07:54 PM

what language are you using?

Also did you remove the comment tags from the thesaurus file and did you
edit it with notepad?

19-Nov-09 02:41 PM

Hi -

Language: American english on the PC, and the coallation for the SQL Server
instance (and all of my instances) is "SQL_Latin1_General_CP1_CI_AS", the
default.

As far as editing, I admit I have looked at the thesaurus file in Notepad, but
after removing comments I saved it through the query editor in SQL 2k5
Enterprise manager, which is presumably unicode aware. A paste of the
contents of the file is shown below in the previous example.

I am wondering - is there isome soft of seperate XML related service which
must be active on the machine for it to properly fetch & interpret the XML
schema of the thesaurus document ??

I am just trying to get a simple, clean test of a thesaurus modification, and
then build on it..

Thanks for any suggestions -

Steve

20-Nov-09 07:45 AM

You edited the American English noise word list. I am not sure if this is
significant or not.

However, SQL FTS is extremely picky with the file type. Can you take the
tseng.xml file, edit it in notepad, and then save it as tsenu.xml and try
again?

Ensure that the timestamp of the tsenu.xml file has changed to reflect the
current date/time.

Hilary