SQL Server Error - What does it mean?
-
I feel like I am in SQL Server hell today. All of a sudden a query that has been running for several weeks gives the following error:
"Could not allocate ancillary table for query optimization. Maximum number of tables in a query (256) exceeded".
There is no way this query accesses 256 tables! It accesses three tables at the most.
Any ideas as to what this means and how to fix it?
Thanks.
-
Is the query complex? Got enough room in tempdb? Updated statistics?
Andy
-
It is a series of queries that build to one final query. But, I have more complex queries than this one that are running fine.
Tempdb has plenty of room. Not sure what you mean by Updated statistics.
-
First is this a 6.5 database? If so what is the exact message with error number I had replyied to this same question before but cannot find.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
-
It is SQL Server 7. The exact error message is what I quoted in my original post.
-
I found out that the error number is 146 and severity is 15.
Will continue to search for solution.
__________________________________
Searching the KB articles is like
picking your nose. You never know
what you'll find.
__________________________________
Searching the KB articles is like
picking your nose. You never know
what you'll find. -
You might find the following article interesting:
http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q308744&
Cheers, hot2use
__________________________________
Searching the KB articles is like
picking your nose. You never know
what you'll find.
__________________________________
Searching the KB articles is like
picking your nose. You never know
what you'll find.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply