How can we help you today?

How can we help you today?

Query processor could not produce a query plan because of the hints defined in this query.

I am getting this error when running dynamic sql with the forceseek query hint.

MGibson February 22, 2021 10:40

0

Comments

1 comment

Hello @MGibson,

Thanks for reaching out!

I have not personally encountered this issue but it does seem related to SSMS (which you may be able to raise a bug with Microsoft). Another user that had the same error along with the forceseek query hint:
https://dba.stackexchange.com/questions/222640/query-processor-could-not-produce-a-query-plan-because-of-the-hints-defined-in-t
In my case I got the same error with my query where somebody used with forceseek hint.
Finally I figured out that table was a HEAP and the creation of a Clustered Index solved the problem.

I hope this helps you out.

Kind regards,
David

David_D February 24, 2021 17:36

0

Add comment

Please sign in to leave a comment.