Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Limit to a UNION?
Message
From
17/06/2005 08:00:39
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Limit to a UNION?
Miscellaneous
Thread ID:
01024245
Message ID:
01024245
Views:
67
Hi all

I'm executing a huge SQL string from c# and i seem to be hitting some sort of limit, the SQL consists of 1000's of UNION selects and I get the following error:

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

Is there a limit to the size of the SQL you can execute?

Thanks
Kev
Next
Reply
Map
View

Click here to load this message in the networking platform