I get the following error:
Msg 8621, Level 17, State 2, Procedure ProcessFliteTracWorkingXML_FTPax, Line 348
The query processor ran out of stack space during query optimization. Please simplify the query.
I have looked at this KB fix, but we are a newer version then in that article:
Also found this post with a similiar issue, but no solution:
Before I call Microsoft Support I thought I would try here first.
I am trying to run a stored proc that basically needs to parse xml messages coming from an outside datasource. We are using SQL Server 2005 SP3 (9.00.4053.00 SP3 Standard Edition). This datasource is an old pervasived database with
not the best data model. So what we wanted to do was pull the raw data as is into a staging table and then convert it to a better data model in our ODS. There are around 300 columns in this table and I have a generic process that pulls the rows
out and converts to XML and saves to a working table (this
View Complete Post