>Hi, people
>
>When running a query I got the message
>
>'The query has been canceled because the estimatesd cost of this query (445) exceeds the configured threshold of 300.'
>
>Is that possible to change this value? Where?
>What are the implications to the overall performance ?
>
>TIA
I agree with Sergey - I would start from trying to optimize this query. May be you can post it? Can you get the estimated query plan?
In addition, this question may be very good to ask in this forum
http://social.msdn.microsoft.com/Forums/en-US/transactsql/threads - you'll get the experts opinions there.
If it's not broken, fix it until it is.
My Blog