ContainsTable returns "Informational: MS Search stop limit reached

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sql411@nospam.com - 01 Jun 2007 18:48 GMT

When I run a containsTable search I get the following error:

Informational: MS Search stop limit reached. The full-text query may have
returned fewer rows than it should.

Error 9926 Severity 10

This is causing erratic results, I see nothing in the ft logs for this
catalog that indicates an error. It doesn't happen on all servers, even
though multiple servers have around the same size catalog as this one, with
the same data types.

I saw something that this was a fix included in SP2 (I'm running SP1) -- but
it was very vague about what it fixed/resolved.

Anyone else have this issue?

Appreciative,
robert towne

Reply to this Message

sql411@nospam.com - 03 Jul 2007 22:18 GMT

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/ftslesld.mspx

states to change the following undocumented 'features':

EXEC sp_configure 'remote query timeout', 10000 -- default is
600 seconds
EXEC sp_fulltext_querytimeout @ftcat = 'fullTextCatalogName',
@timeout = 10000000 -- in milliseconds

this resolved my problem, even though MS PSE stated only SP2 was required.

> When I run a containsTable search I get the following error:
>
[quoted text clipped - 15 lines]
> Appreciative,
> robert towne

Reply to this Message