Re: Searching on #

Tech-Archive recommends: Speed Up your PC by fixing your registry

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

--
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
"Mike" <Mike@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D770FF8C-AE71-482D-A4B5-FD4ABF41804F@xxxxxxxxxxxxxxxx
Hi,

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

ta,

mike,

"Mike" wrote:

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,

"Hilary Cotter" wrote:

can you also do this

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

on both machines and post the results back here?

--
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
"Mike" <Mike@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F6F33158-013B-4C07-93AB-FC5F37D9430B@xxxxxxxxxxxxxxxx
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,





.

Relevant Pages

  • Re: merge Replication across Internet
    ... Looking for a SQL Server replication book? ... >> Using a VPN is not essential. ... >> Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: merge Replication across Internet
    ... Looking for a SQL Server replication book? ... >> Using a VPN is not essential. ... >> Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... I also checked the individual patch levels for the .NET drivers, SQL Server ... The SQL Server is fully patched, however Windows Update reported that the OS ... Lock pages in memory -- I guess you might have taken care of it as well. ...
    (microsoft.public.sqlserver.clustering)
  • RE: migrating from wmsde to sql server
    ... Click Start, point to All Programs\Microsoft SQL Server, and then click ... then click New SQL Server Registration. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)