Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
byrmol
Shed Building SQL Farmer
1591 Posts |
 Posted - 2006-11-15 : 16:18:17
|
quote:
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.
I am very impressed with the detail of this message.And yes, I was doing the unthinkable.. Updating a PK...I suppose I should blame myself for a poor key choice, but it is the first key update of this table in 9 months. Cascading is on so deletion is not an option....Easy fix, 2 statements..key column update, the non-key column update...DavidMProduction is just another testing cycle |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-11-15 : 16:33:44
|
nice.and shame on you for updating the CI  Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-11-15 : 17:47:04
|
I have not seen that one before.But some other weird ones, usally related to parallellism and, yes ntext columns..It seems there are some issues with QO when dealing with these things.But being a nice guy I can have oversight for some weirdness  rockmoose |
|
|
|
|
|
|
Never seen this error before...