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.
Filed under: Uncategorized