containstable(isabout...) query length

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shay cohen - 19 May 2005 08:42 GMT

Hi ,
i am using a very long query in a containstable predicate with an isabout
search method.

somthing like this :CONTAINSTABLE( dbo.TBL_FTS_DATA,FreeTextDump,
'ISABOUT(.....

my problem is that when my' ISABOUT is more then 8000 chars long the query
fails.
it seems that the isabout portion of the command is limited to 8000 chars.
is there any way around this?

thanks

shay

Reply to this Message

Hilary Cotter - 19 May 2005 23:11 GMT

No, this is hard coded. Have you seen this kb?

http://support.microsoft.com/default.aspx?scid=kb;en-us;317486

A problem like this was solved with SP3. I take it you are above Sp3. One of
the work arounds is that you could do two separate ContainsTable queries and
AND or OR them.

Another problem is with near which is hard coded as 1366 words IIRC.

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hi ,
> i am using a very long query in a containstable predicate with an isabout
[quoted text clipped - 11 lines]
>
> shay

Reply to this Message