containstable(isabout...) query length

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
No, this is hard coded. Have you seen this kb?
http://support.microsoft.com/default...b;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.
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
"shay cohen" <shay@.infospheraltd.com> wrote in message
news:egjgSYEXFHA.3760@.TK2MSFTNGP15.phx.gbl...
> 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
>