I get the following message when I'm inserting a row into a table. The
statement is very simple, but there is a large amount of data going into one
column.

Internal Query Processor Error: The query processor ran out of stack space
during query optimization

All the KB articles I've found so far refer to queries that have a large
number of elements in an IN clause, or a CASE statement with a large number
of WHEN clauses - niether of which fit this scenario.

Has anyone else had this problem and found a way around it. I can't
replicate the problem on any of our development or test servers - it only
happens on the production server. All servers are the same spec - W2K
Server and SQL Server 2000 - all service packed up.

Any help appreciated.

Cheers,

Cameron

Cameron,

Can you provide more information? What is the structure of the table,
and what is the insert statement, or at the least, what form does it have -
insert .. values, insert into .. select? Are there any triggers on the
table?
What indexes are on the table? Are any of the tables involved actually
views?

It's hard to suggest a way around a problem with this little information
about what you are trying to do.

-- Steve Kass
-- Drew University
-- Ref: 20CAE9D5-49D4-43CF-A330-EE3EB766EF1A

cj wrote:

>I get the following message when I'm inserting a row into a table. The
>statement is very simple, but there is a large amount of data going into one
>column.
>
>Internal Query Processor Error: The query processor ran out of stack space
>during query optimization
>
>All the KB articles I've found so far refer to queries that have a large
>number of elements in an IN clause, or a CASE statement with a large number
>of WHEN clauses - niether of which fit this scenario.
>
>Has anyone else had this problem and found a way around it. I can't
>replicate the problem on any of our development or test servers - it only
>happens on the production server. All servers are the same spec - W2K
>Server and SQL Server 2000 - all service packed up.
>
>Any help appreciated.
>
>Cheers,
>
>Cameron
>
>
>
>

Have you got an insert trigger on the table? What are your settings for
nested and recursive triggers?

HTH,


--
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com

"cj" <smuffnstuff@hotmail.com> wrote in message
news:O7Ptg8aoDHA.3612@TK2MSFTNGP11.phx.gbl...
> I get the following message when I'm inserting a row into a table. The
> statement is very simple, but there is a large amount of data going into
one
> column.
>
> Internal Query Processor Error: The query processor ran out of stack space
> during query optimization
>
> All the KB articles I've found so far refer to queries that have a large
> number of elements in an IN clause, or a CASE statement with a large
number
> of WHEN clauses - niether of which fit this scenario.
>
> Has anyone else had this problem and found a way around it. I can't
> replicate the problem on any of our development or test servers - it only
> happens on the production server. All servers are the same spec - W2K
> Server and SQL Server 2000 - all service packed up.
>
> Any help appreciated.
>
> Cheers,
>
> Cameron
>
>