Error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Deniz Emeci - 09 Nov 2007 15:18 GMT

I have full text catalog on my table.
SELECT TOP 10 * FROM MyTable My(NOLOCK)
WHERE CONTAINS My.*, '"a.b.c.d*"')
query execute error;
"Msg 9937, Level 16, State 5, Line 1
Too many full-text columns or the full-text query is too complex to be
executed."

otherwise another query which doesn't have --"--
SELECT TOP 10 * FROM MyTable My(NOLOCK)
WHERE CONTAINS My.*, 'a.b.c.d*')
returns data normally.

what is the differences between them?
Is anyone can help me?

Reply to this Message

Hilary Cotter - 09 Nov 2007 15:39 GMT

The wildcard is applied to each term in your query, so its a* and b* and c*
and d*. That is why you are getting the error. I can't see a good solution
to this.

Signature

RelevantNoise.com - dedicated to mining blogs for business intelligence.

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

>I have full text catalog on my table.
> SELECT TOP 10 * FROM MyTable My(NOLOCK)
[quoted text clipped - 11 lines]
> what is the differences between them?
> Is anyone can help me?

Reply to this Message

Deniz Emeci - 09 Nov 2007 15:48 GMT

a.b.c.d is one term like u.s.a.(united states of america)
so i dont want to divide my term.

> The wildcard is applied to each term in your query, so its a* and b* and c*
> and d*. That is why you are getting the error. I can't see a good solution
[quoted text clipped - 15 lines]
> > what is the differences between them?
> > Is anyone can help me?

Reply to this Message