Re: KB889708

From: John Kane (jt-kane_at_comcast.net)
Date: 12/23/04 

Date: Wed, 22 Dec 2004 17:41:31 -0800

Pineda,
Yes, that is correct. In fact, all FT Population methods - Full, Incremental
as well as "Change Tracking" with "Updated Index in Background" enabled
access and use the language-specific noise word files during the FT Indexing
(or gatherer) process.

Hope that helps!
John 

-- 
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Pineda" <Pineda@discussions.microsoft.com> wrote in message
news:1F5DBB5A-3A50-45B5-A0E5-7B1E861E6420@microsoft.com...
> Jhon,
>
> My environment is active/passive, but my question is not it. The KB says
the
> results are different because the noise word file is not replicate in the
> passive node, but my question is if it also influence in the incremental
> population, because the gatherer process uses the noise word file too.
Then,
> when the FTS and SQL are in the second node, the FTS could be indexed the
> noise words too, because my noise word file is not replicate in this node.
>
>
> "John Kane" wrote:
>
> > Pineda,
> > Ok, I found the KB article that you're referring to - "The full-text
search
> > results that are returned in a clustered SQL Server 2000 environment may
be
> > different when the active node changes" at
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;889708
> >
> > As this is a new KB article, and I don't have clustered environment to
test
> > this, but I doubt it as the CAUSE section states that "This problem
occurs
> > when the noise word file location is not replicated between the nodes in
the
> > cluster. When SQL Server 2000 is installed in a cluster". So, in affect
the
> > different results are caused by the language-specific noise word file
not
> > being installed on the 2nd node, thus causing different to results when
> > failover occurs and makes the 2nd node the active node. Note, this
assumes
> > an Active/Passive environment and not an Active/Active (or
Multi-instance
> > model).
> >
> > What is your clustered environment - Active/Passive or Active/Active?
Are
> > you seeing the symptoms of this KB article in your environment?
> >
> > Thanks,
> > John
> >
> >
> > "Pineda" <Pineda@discussions.microsoft.com> wrote in message
> > news:6500B31B-8544-4136-869B-FDEC137854EF@microsoft.com...
> > > Does anyone know if this affects when the FTS os on the second node to
> > > incremental population?
> > >
> > > Thxs.
> >
> >
> >

Relevant Pages

  • Re: Why Cluster in a test Environment?
    ... If your apps are not failover aware, ... SQL Server 2000 then takes anywhere from 30 seconds to minutes before ... a cluster but not appear in a standalone server. ... A non-clustered environment would not allow accurate stress testing do ...
    (microsoft.public.sqlserver.clustering)
  • Re: KB889708
    ... As this is a new KB article, and I don't have clustered environment to test ... when the noise word file location is not replicated between the nodes in the ... When SQL Server 2000 is installed in a cluster". ...
    (microsoft.public.sqlserver.fulltext)
  • Re: KB889708
    ... My environment is active/passive, but my question is not it. ... because the gatherer process uses the noise word file too. ... because my noise word file is not replicate in this node. ... When SQL Server 2000 is installed in a cluster". ...
    (microsoft.public.sqlserver.fulltext)
  • Re: IP Restructuring for SQL Server Cluster
    ... The key to changing IP addresses on a cluster is to make sure the cluster ... always has a valid communication path between all nodes. ... active-passive SQL Server 2000 Cluster environment on both sites. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Testing for SQL Cluster
    ... > of SQL Server on cluster environment. ... > happening successfully and confirm the SQL Server Installation on cluster ...
    (microsoft.public.sqlserver.clustering)