A query cannot update a text, ntext, or image column and a clustering key at the same time

The above error was killing my team's time.Here how we solve this.

Here we goes...

Right Click on Table-->Design Mode -->Right Click on Coloumn Name -->Indexes/keys..-->Uncheck "creat as clustered"

For more
http://groups-beta.google.com/group/microsoft.public.sqlserver.programming/browse_frm/thread/ad3b8622be49ea94/3276e0519e823bad?tvc=1&q=a+query+cannot+update+a+text,+ntext,+or+image+column+and+a+clustering+key+at+the+same+time&hl=en#3276e0519e823bad

Cheers..

Suresh Behera

1 Comment

  • select * from table1
    where details ='real';


    But details of the type of ntext ,does not accept this (like)condition To become valid Alsellict


    And I want to make sure that equal place like

    plz any person help me

Comments have been disabled for this content.