"segis bata" <segisbata@hotmail.com> wrote in message
news:exo1vo0qGHA.4192@TK2MSFTNGP04.phx.gbl...
> Hello everyone,
>
> I'm having this problem, I'm trying to run a query that consists of six
> tables and one view (all joined together)
>
> When I run it without anything on the where (or just one criteria in the
> where clause) works just fine, but if I run it with two criteria in the
> where clause I get the following message:
>
> <<< [Microsoft][ODBC SQL Server Driver][SQL Server]Could not insert a row
> larger than the page size into a hash table. Resubmit the query with the
> ROBUST PLAN hint. >>>
>
> And when I do so -adding the ROBUST PLAN option-, I get the following
> message:
>
> <<< 'Query hints' cannot be used in this query type. >>>
>
> Any idea what is going on?!? please let me know!!!
>
> TIA,
> sb-r
>

> I'm having this problem, I'm trying to run a query that consists of six
> tables and one view (all joined together)
>
> When I run it without anything on the where (or just one criteria in the
> where clause) works just fine, but if I run it with two criteria in the
> where clause I get the following message:
>
><<< [Microsoft][ODBC SQL Server Driver][SQL Server]Could not insert a row
> larger than the page size into a hash table. Resubmit the query with the
> ROBUST PLAN hint. >>>
>
> And when I do so -adding the ROBUST PLAN option-, I get the following
> message:
>
><<< 'Query hints' cannot be used in this query type. >>>
>
> Any idea what is going on?!? please let me know!!!