SQL Server 7.0 query problem - TechRepublic
General discussion
September 18, 2001 at 10:04 PM
ohjani

SQL Server 7.0 query problem

by ohjani . Updated 24 years, 7 months ago

i get this error when i tried to INNER JOIN 2 Views (each view contains a few sub queries/views). pls tell me what is the problem.

“Could not allocate table for query optimization. Maximum number of tables in a query (256) exceeded.”

i’m sure the total amount of tables involved in all the queries doesn’t exceed 256. each of the views prob has abt not more than 10 sub views. therefore the total number of all involved tables shouldn’t exceed 20.

btw, how do i turn off Query Optimization? i’ve unchecked the Auto Create Statistic and Auto Update Statistic in the database properties.

This discussion is locked

All Comments