Searching on #

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike - 18 Jul 2007 08:32 GMT

Hi,

I have 2 identical sql 2000 servers with full text indexing enabled on both.
I have the same data structure etc however on one sql server I can run SELECT
* FROM tblTest WHERE CONTAINS(text,"'C#'") and get results however running on
the second I get a message saying the query contains nothing but noise words.

I've checked the noise.eng and noise.enu files are they are both identical
on both servers.

Any ideas more than welcome!

ta,

Mike,

Reply to this Message

Daniel Crichton - 18 Jul 2007 11:47 GMT

Mike wrote on Wed, 18 Jul 2007 00:32:07 -0700:

> Hi,
>
[quoted text clipped - 8 lines]
>
> Any ideas more than welcome!

Are they both on the same version of Windows too? I think that on Windows
2000 you'll not get results, but on Windows 2003 you will. Also, check the
text in the rows - only the captilised C# will be indexed as C#, if you have
c# it'll be treated as c and so will be removed if you have c in your noise
words files.

Dan

Reply to this Message

Hilary Cotter - 18 Jul 2007 13:55 GMT

can you also do this

select @@language
GO
sp_configure 'default full-text language'
GO

on both machines and post the results back here?

Signature

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hi,
>
[quoted text clipped - 15 lines]
>
> Mike,

Reply to this Message

Mike - 18 Jul 2007 14:44 GMT

Thanks for the ideas so quickly.

One server is a 2000 box and one is 2003, sorry I should have mentioned this
however its the 2000 box which is returning results, the 2003 server errors.

I've ran the statements below and both return "us_english" with a
config_value of "1033".

Any more ideas greatly appriciated!

Kind regards,

mike,

> can you also do this
>
[quoted text clipped - 24 lines]
> >
> > Mike,

Reply to this Message

Mike - 19 Jul 2007 19:34 GMT

Hi,

Just wondering if anyone had any further ideas/advice? :o)

ta,

mike,

> Thanks for the ideas so quickly.
>
[quoted text clipped - 38 lines]
> > >
> > > Mike,

Reply to this Message

Hilary Cotter - 20 Jul 2007 11:21 GMT

The behavior of the word breakers changed between Windows 2000 and 2003. I
don't know how to get around this problem.

Signature

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hi,
>
[quoted text clipped - 53 lines]
>> > >
>> > > Mike,

Reply to this Message

Mike - 20 Jul 2007 11:32 GMT

Hi,

OK no problem :o(

Thanks for your speedy response and advice though :o)

Kind regards,

mike,

> The behavior of the word breakers changed between Windows 2000 and 2003. I
> don't know how to get around this problem.
[quoted text clipped - 56 lines]
> >> > >
> >> > > Mike,

Reply to this Message