How do I change an ntext field to nvarchar in sql-server

coldfall

Field c in table t is of type ntext.

I used alter table [t] alter column [c] nvarchar (255)

It can be executed in sql2005, and an error is reported in sql2000. It seems that the ntext column cannot be changed.

Is there any solution

fanfan1980

alter table [t] add [c1] nvarchar (255)

update [t] set [c1] = [c]

alter table [t] drop column [c]

EXEC sp_rename '[t]. [C1]', '[c]', 'COLUMN'

coldfall

Thank you, this is ok. But is there no simpler way? Such as system stored procedures. . . . .

coldfall

It can be changed directly in the Enterprise Manager. I don't think MS will leave an interface for myself, right?