Full text issue

Hello,

I run a music related website (www.LowestCostMusic.com) and I'm using the SQL2000 full text search engine.

If you go to the site via this link... It would be searching on the phrase 'the way it is'

http://www.lowestcostmusic.com/search2.asp?search=the+way+it+is

Which is all noise words... yet could be a title of some sheet music that we carry. I need to know how to build the SQL full text catalog to allow this search to work properly... Any ideas? Thanks!

-MattMatt,

Thanks for using Microsoft SQL Server 2000 and Full-Text Search on your web site. This should help:

You need to update your noise words list and then repopulate your Full-Text index in order to accept searches on titles such as "the way it is" . You may find your noise word files under:

\Program Files\Microsoft SQL Server\MSSQL$INSTANCENAME\Ftdata\SQLServer\Config\ noise.enu (for US English)

You may add words to be excluded from the index, and likewise remove words that you would like included.

Once you are satisfied with changes, restart MSSearch service and you will need to repopulate your catalogs.

This should fix your problem right away.

All the best,
--andrew

Full Text Catalog Not Building

Hi,
We have created a catalog for our search engine in our website and
everything was working fine before. Right after we created a new
stored procedure that updates the table in which the catalog was
referencing to, our search engine stopped working. We have created the
catalog multiple times, restarting services, repopulating catalogs,
etc. but got nothing working.
Do you guys have any idea about this?
Any help is really appreciated.
Baldwin
bbudiongan@.misicompany.com
Are there any error messages in the event log from mssci or mssearch?
<ibaldwinjr@.gmail.com> wrote in message
news:1177936766.967895.276810@.h2g2000hsg.googlegro ups.com...
> Hi,
> We have created a catalog for our search engine in our website and
> everything was working fine before. Right after we created a new
> stored procedure that updates the table in which the catalog was
> referencing to, our search engine stopped working. We have created the
> catalog multiple times, restarting services, repopulating catalogs,
> etc. but got nothing working.
> Do you guys have any idea about this?
> Any help is really appreciated.
> Baldwin
> bbudiongan@.misicompany.com
>
|||On Apr 30, 10:04 am, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:
> Are there any error messages in the event log from mssci or mssearch?<ibaldwi...@.gmail.com> wrote in message
> news:1177936766.967895.276810@.h2g2000hsg.googlegro ups.com...
>
>
>
>
> - Show quoted text -
Thanks for the immediate response. I am still trying to get the logs
from the DBA guys but what they say is they got an error like File Not
Found in th FTDATA folder. I asked them to recreate the catalog but
they can't. Instead they are presented with the error message saying
like start the rebuild, then full repopulate. I hope this makes sense
to you.
Baldwin