sql server full text search: I perform a query against a database and it returns one set of results. I
perform this query on an "identical" database and it returns a subtly
different set of results.

In detail.

SERVER A

I have a table that has a field 'myField' that is of datatype TEXT.

This table has a full-text index on it using the English (United Kingdom)
word breaker. The catalog is both built and fully populated.

One of the rows contains the data
'Z42/Z43/Z45/Z51/Z52/Z53/Z54/X63/X70/X73/X80/X83/X84/X85/X125/A10'

I run the following SQL query:
select * from myDB..myTable where contains(myField,'x73')
and the result set does NOT return this row.

I back this database up and restore it on Server B

I ensure that the same full-text index exists (same word-breaker language).
I build the catalog and fully populate it. Number of records and size are
the same as on server A.

I perform the same SQL query and this time it DOES return the row in
question.

DETAILS ABOUT THE SERVERS (I can't believe that the following would make a
difference, but hey, perhaps it does...?):

SERVER A - the one the query does not return the row
Windows 2000 sp3
SQL Server Enterprise Edition, sp3a, server collation = Latin1_General_CI_AS

SERVER B
Windows 2003
SQL Server Standard Edition, sp3a, server collation = Latin1_General_CI_AS

The same collation (Latin1_General_CI_AS) exists at the field level...

Running out of ideas....

Thanks for reading this

Griff

Ah

Think I may have solved it (but I'm not certain so if anyone could confirm
or deny the following that would be extremely helpful)

I think that the Win2003 computer has a different operating system DLL that
defines noise words and this is used in the full-text cataloguing exercise.
Hence the difference...I think.

Griff

Griff wrote on Wed, 25 Jan 2006 09:48:15 -0000:

[quoted text, click to view]

Windows 2003 does indeed have a different word breaker than Windows 2000,
searching this group will turn up many posts about this. Have you tried
using the Neutral word breaker?

Dan