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"

Cheers..

Suresh Behera

Posted: Aug 18 2005, 11:28 AM by Suresh Behera | with 1 comment(s)

Filed under: .Net

Comments

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

# October 28, 2008 6:00 AM