Hi -

I am running SQL 2k5 Developer Ed on Win XP Pro, current on SPs and patches
(my dev machine at the moment),
server collation: SQL_Latin1_General_CP1_CI_AS

and tried to create a simple FT index Thesaurus test, as follows:

create table FT_test (
FT_test_Id int identity(1,1) ,
theText varchar(8000)
)

insert FT_test values('run')

CREATE FULLTEXT CATALOG [test]
IN PATH N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData'
WITH ACCENT_SENSITIVITY = OFF
AS DEFAULT AUTHORIZATION [dbo]

CREATE unique CLUSTERED INDEX [idx_FT_test] ON [dbo].[FT_test] (FT_test_Id
ASC)

alter table FT_test add CONSTRAINT [idx_FT_test_PK] PRIMARY KEY NONCLUSTERED
( FT_test_Id ASC )

CREATE FULLTEXT INDEX ON [dbo].[FT_test](theText)
KEY INDEX [idx_FT_test] on [test] with CHANGE_TRACKING OFF , NO POPULATION

Alter Fulltext Index on [dbo].[FT_test] start Full Population

and waited a few seconds. It all seemed to execute successfully.

Then, I altered the file:
tsENU.xml
in the path:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData

to read:
<XML ID="Microsoft Search Thesaurus">
<thesaurus xmlns="x-schema:tsSchema.xml">
<diacritics_sensitive>0</diacritics_sensitive>
<expansion>
_{Internet Explorer}
_IE
_IE5
</expansion>
<replacement>
<pat>NT5</pat>
<pat>W2K</pat>
_{Windows 2000}
</replacement>
<expansion>
_run
_jog
</expansion>
</thesaurus>
</XML>

in a "SQL Server Enterprise Manager" "New Query" text pain.

I then restarted the "SQL Server FullText Search (SQL2K5)" service in the
"Services" application on the computer, and it restarted successfully.

The following query should then return 1 row:

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

instead it returns nothing.

I am trying to simply create and correctly apply an FT index Thesaurus file.

Q1: What am I doing wrong in applying the thesaurus file ?

Q2: Will having a few hundred entries in a correctly configured and running
FT index thesaurus file slow down either FT queries or FT crawls ?

Thanks for any insight anyone has,

SteveM