Full Text Search in SQL Server 2000

I'm having trouble retrieving results from a SP that uses the Contains
or FREETEXT functions.
CREATE PROCEDURE dbo.bugFuzzySearchDesc
@.SearchTerm varchar(2048)
AS
SELECT
issue_id,
issue_description
FROM
bug_issues
WHERE
FREETEXT(issue_description, @.SearchTerm);
/*CONTAINS(issue_description, @.SearchTerm);*/
The Parameter that gets passed to the SP looks like this:
'"Mercury*" OR "Midware*"'
The column being searched on has the following value in one particular
record:
"Setup Mercury Midware for Mercury Payment Systems"
Yet, the query returns no results.
Warm Regards,
Lee
"Upon further investigation it appears that your software is missing
just one thing. It definitely needs more cow bell..."
Lee enlightened me by writing:

> "Setup Mercury Midware for Mercury Payment Systems"
> Yet, the query returns no results.
Never mind. I'm using a DB on our hosted website and they
re-index/re-populate the catalogs very 24hrs. Makes sense if it's an
expensive process...
Warm Regards,
Lee
"Upon further investigation it appears that your software is missing
just one thing. It definitely needs more cow bell..."

Full Text Search in SQL Server 2000

I'm having trouble retrieving results from a SP that uses the Contains
or FREETEXT functions.
CREATE PROCEDURE dbo.bugFuzzySearchDesc
@.SearchTerm varchar(2048)
AS
SELECT
issue_id,
issue_description
FROM
bug_issues
WHERE
FREETEXT(issue_description, @.SearchTerm);
/*CONTAINS(issue_description, @.SearchTerm);*/
The Parameter that gets passed to the SP looks like this:
'"Mercury*" OR "Midware*"'
The column being searched on has the following value in one particular
record:
"Setup Mercury Midware for Mercury Payment Systems"
Yet, the query returns no results.
--
Warm Regards,
Lee
"Upon further investigation it appears that your software is missing
just one thing. It definitely needs more cow bell..."Lee enlightened me by writing:
> "Setup Mercury Midware for Mercury Payment Systems"
> Yet, the query returns no results.
Never mind. I'm using a DB on our hosted website and they
re-index/re-populate the catalogs very 24hrs. Makes sense if it's an
expensive process...
--
Warm Regards,
Lee
"Upon further investigation it appears that your software is missing
just one thing. It definitely needs more cow bell..."

Full Text Search in SQL Server 2000

I'm having trouble retrieving results from a SP that uses the Contains
or FREETEXT functions.
CREATE PROCEDURE dbo.bugFuzzySearchDesc
@.SearchTerm varchar(2048)
AS
SELECT
issue_id,
issue_description
FROM
bug_issues
WHERE
FREETEXT(issue_description, @.SearchTerm);
/*CONTAINS(issue_description, @.SearchTerm);*/
The Parameter that gets passed to the SP looks like this:
'"Mercury*" OR "Midware*"'
The column being searched on has the following value in one particular
record:
"Setup Mercury Midware for Mercury Payment Systems"
Yet, the query returns no results.
Warm Regards,
Lee
"Upon further investigation it appears that your software is missing
just one thing. It definitely needs more cow bell..."Lee enlightened me by writing:

> "Setup Mercury Midware for Mercury Payment Systems"
> Yet, the query returns no results.
Never mind. I'm using a DB on our hosted website and they
re-index/re-populate the catalogs very 24hrs. Makes sense if it's an
expensive process...
Warm Regards,
Lee
"Upon further investigation it appears that your software is missing
just one thing. It definitely needs more cow bell..."

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