February 11, 2009 at 3:32 am
Hi Everybody,
I got the following error while running a query.
'The query has been cancelled because the estimated cost of the query(35) exceeds the configured threshold of 5. Contact the system administrator.'
Can any one help me in solving the problem
Who is wise? He that learns from everyone. Who is powerful? He that governs his passions. Who is rich? He that is content. Who is that? Nobody.:)
February 11, 2009 at 3:57 am
See here.
It would also be good practice to examine the query to establish if it can be optimised.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
February 11, 2009 at 6:42 am
SET quer time out value higher than default.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply