ContainsTable returns "Informational: MS Search stop limit reached -- sql server full text search

sql411 NO[at]SPAM nospam.com
6/1/2007 10:48:00 AM

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,

sql411 NO[at]SPAM nospam.com
7/3/2007 2:18:03 PM

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.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server full text search

sql server full text search : ContainsTable returns "Informational: MS Search stop limit reached