SQL Server2008 Full Text Search error message

Hi

I am wokring on a trail version of Sql Server 2008 on Windows XP. I am
implementing full text search for one of my requirement.

Created two relational tables and populated with data
Created full text catalog with two tables
Enabled Full Text Search and made a key indexed

Developed a stored procedure to populate data from two tables with
FREETEXT predicate

First couple of times it throws an error and later no error

Error Message:

Word breaking timed out for the full-text query string. This can
happen if the wordbreaker took a long time to process the full-text
query string,
or if a large number of queries are running on the server. Try running
the query again under a lighter load.


Tried following workarounds but not resolved:

1. I Verifed fdhost.exe is up and running
2. Restarted database instance

Data is very less in these two tables (5 rows)

Any help is greatly appreciated!

can you issue a call to sp_fulltext_service 'restart_all_fdhosts' and see if
that helps?
<kondapra.TakeThisOut@gmail.com> wrote in message
news:7e352dfc-fdd5-4e3c-9c72-4eec5198c120@d31g2000hsg.googlegroups.com...
> Hi
>
> I am wokring on a trail version of Sql Server 2008 on Windows XP. I am
> implementing full text search for one of my requirement.
>
> Created two relational tables and populated with data
> Created full text catalog with two tables
> Enabled Full Text Search and made a key indexed
>
> Developed a stored procedure to populate data from two tables with
> FREETEXT predicate
>
> First couple of times it throws an error and later no error
>
> Error Message:
>
> Word breaking timed out for the full-text query string. This can
> happen if the wordbreaker took a long time to process the full-text
> query string,
> or if a large number of queries are running on the server. Try running
> the query again under a lighter load.
>
>
> Tried following workarounds but not resolved:
>
> 1. I Verifed fdhost.exe is up and running
> 2. Restarted database instance
>
> Data is very less in these two tables (5 rows)
>
> Any help is greatly appreciated!