<phadke@gmail.com> wrote in message
news:1129632193.545575.218860@g47g2000cwa.googlegroups.com...
>I just setup my server with win2k3 sp1 and ALL the latest patches, plus
> sql 2004 standard sp4.
>
> I keep getting this error on a table with 39000 records where I am
> running a basic wildcard CONTAINS fulltext query for "cer*"
>
> Server: Msg 7643, Level 16, State 1, Line 1
> Your search generated too many results. Please perform a more specific
> search.
>
> There should be about 30000 records.
>
> I noticed on technet that this was a problem pre sp2 in sql, but was
> since patched. Has the bug recently been re-introduced in some combo
> of win2k3 and sql patches?
>

<phadke@gmail.com> wrote in message
news:1129660216.247521.205300@g47g2000cwa.googlegroups.com...
> John,
>
> Just to clarify, is this a hard limit of 2000, because I am able to see
> the result set for queries that return a con query with 17-18k records
> with no problem.
>
> I saw another technote that the problem limit was at approx 20k
> records:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q296456
>
> Thanks for the info,
>
> Aditya
>

"Aditya Phadke" <phadke@gmail.com> wrote in message
news:1129660966.529955.176010@g44g2000cwa.googlegroups.com...
> Also, is this limitation common to sql 2005?
>

"Aditya Phadke" <phadke@gmail.com> wrote in message
news:1129672239.794380.257680@o13g2000cwo.googlegroups.com...
> Ok, now I am really confused....I ran a fulltext query for "c*" on a
> database on another server. This database has 2.4 Million Records.
>
> This server is Win2k3 (no SP) and SQL 2k SP3.
>
> When I run the query, I get 900,000 records back without an error
> message.
>