|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
internal query processor error
hi
using sql server 2000 sp3... trying to execute sql statement which has complex subqueries from perl using DBI DBD ODBC modules and this error comes up if same sql statement executed from query analyzer, sql statement gets executed successfully error: DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL Server]Internal Query Processor Error: The query processor ran out of stack space during query optimization. (SQL-42000)(DBD: st_execute/SQLExecute err=-1) any help or pointers would be really helpful thanks in advance Krishna
Check it out FIX: A SELECT Statement with a Large IN Clause May Fail with a Stack Overflow and the Client Disconnects http://support.microsoft.com/default.aspx?scid=kb;en-us;278421 Show quoteHide quote "krishna" <kris***@discussions.microsoft.com> wrote in message news:D5C9D467-0FD5-4382-B048-2D2DF2B98429@microsoft.com... > hi > using sql server 2000 sp3... > trying to execute sql statement which has complex subqueries from > perl using DBI DBD ODBC modules and this error comes up > if same sql statement executed from query analyzer, sql statement gets > executed successfully > > error: > DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL > Server]Internal Query Processor Error: > The query processor ran out of stack space during query optimization. > (SQL-42000)(DBD: st_execute/SQLExecute err=-1) > > any help or pointers would be really helpful > thanks in advance checked the fix in the support site
the sql statement gets executed sucessfully through query analyzer or from asp page it gives error when executed from perl DBI DBD ODBC module why is this difference Show quoteHide quote "Uri Dimant" wrote: > Krishna > Check it out > FIX: A SELECT Statement with a Large IN Clause May Fail with a Stack > Overflow and the Client Disconnects > http://support.microsoft.com/dÂefault.aspx?scid=kb;en-us;2784Â21 > > > > > > > "krishna" <kris***@discussions.microsoft.com> wrote in message > news:D5C9D467-0FD5-4382-B048-2D2DF2B98429@microsoft.com... > > hi > > using sql server 2000 sp3... > > trying to execute sql statement which has complex subqueries from > > perl using DBI DBD ODBC modules and this error comes up > > if same sql statement executed from query analyzer, sql statement gets > > executed successfully > > > > error: > > DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL > > Server]Internal Query Processor Error: > > The query processor ran out of stack space during query optimization. > > (SQL-42000)(DBD: st_execute/SQLExecute err=-1) > > > > any help or pointers would be really helpful > > thanks in advance > > > I guess that rules out Microsoft ODBC (used by Query Analyzer) and probably
points to something in your Perl module as the cause. Try using a newer module. Please post your query here. Adrian Show quoteHide quote "krishna" <kris***@discussions.microsoft.com> wrote in message news:1F2DA04B-AB16-4489-8006-60503E51DEBE@microsoft.com... > checked the fix in the support site > the sql statement gets executed sucessfully through > query analyzer > or from asp page > it gives error when executed from perl DBI DBD ODBC module > why is this difference > > > "Uri Dimant" wrote: > >> Krishna >> Check it out >> FIX: A SELECT Statement with a Large IN Clause May Fail with a Stack >> Overflow and the Client Disconnects >> http://support.microsoft.com/default.aspx?scid=kb;en-us;278421 >> >> >> >> >> >> >> "krishna" <kris***@discussions.microsoft.com> wrote in message >> news:D5C9D467-0FD5-4382-B048-2D2DF2B98429@microsoft.com... >> > hi >> > using sql server 2000 sp3... >> > trying to execute sql statement which has complex subqueries from >> > perl using DBI DBD ODBC modules and this error comes up >> > if same sql statement executed from query analyzer, sql statement gets >> > executed successfully >> > >> > error: >> > DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server Driver][SQL >> > Server]Internal Query Processor Error: >> > The query processor ran out of stack space during query optimization. >> > (SQL-42000)(DBD: st_execute/SQLExecute err=-1) >> > >> > any help or pointers would be really helpful >> > thanks in advance >> >> >>  
Other interesting topics
two applications, one or two databases?
Restore logs question schedule job no locks exist Monitor Data and Log File Growth Isolation Levels, Lost Update anomaly and ADO.NET SUBSTR Function : ASA / SQL 2000; Substring is calculated using bytes, NOT characters DBCS characters cannot be input at varchar column in SQL 2000 Eng Seemingly lost data after unzipping Adding New Languages |
|||||||||||||||||||||||
