the query processor could not produce a query plan from the optimizer because a query cannot update a text ntext or image column and a clustering key

Heres is the solution if see the error something like:

the query processor could not produce a query plan from the optimizer because a query cannot update a text ntext or image column and a clustering key at the same time.

In your update sql statement dont set the primary key and index/clustered key values
and also i guess the ntext or image fields… and that shud fix this silly problem which I know is annoying.

About the author

I work with customers helping them achieve more using Microsoft Technologies. I am in my 9th year with Microsoft as of March 2020. I get to work with really smart people (both at Microsoft and Customers). Helping customers, removing any blockers, rapid prototyping is my core work.