|
|
||||||
|
#1
10-08-08, 03:57 PM
|
|
|
|
|
Hi there,
I get the error above when I try to step into a SQL Server 2005 stored procedure using BIDS. The procedure runs OK when you execute it. Does anyone know why this is happening? |
|
|
|
#2
10-08-08, 04:11 PM
|
|
|
|
|
I found the cause of the error. It is a simple delete statement. It's not
the only delete statement that is in the stored procedure, but unless I comment it out, then I cannot step into the procedure. |
|
|
| Similar Threads | |
| The query processor ran out of stack space during query optimization. Please simplify the query. How can I delete some rows from a database when I get the above error? It is a simple delete from table where column = value type statement. |
|
| Simple SQL generates: Internal Query Processor Error: The query processor could not produce a query plan. I get this error on a very simple stored procedure that is just doing an insert into a 4 column table on SQL Server 2005 Msg 8624, Level 16, State 1,... |
|
| Error message code 8621 : The query processor ran out of stack space during query optimization Hi, I'm facing problem with sql request with SQL Server 2005. I have a 3-tier architecture. I'm using a web application running under Tomcat and storing data in SQL Server.... |
|
| SQL Server 2005 -- Internal Query Processor Error: The query processor could not produce a query plan Hi all I migrated a database from SQLServer 2000 (Standard edition) to SQLServer 2005, standard, SP1, on Windows XP Prof, SP3 After migration I get the following... |
|
| Internal Query Processor Error: The query processor could not produce a query plan. Contact your primary support provider for more information Hi All, We have a problem with a query that after using it for some months without any problem suddenly throws a error : Internal Query Processor Error: The query processor... |
|
|
All times are GMT. The time now is 10:50 AM. | Privacy Policy
|
The query processor ran out of stack space during query optimization. Please simplify the query.