text to ntext

[ShankarPS]

Can anyone help me on how to change text field to ntext (ms-sql 2000), not using enterprise manager, rather programmatically ? or article that says it is not possible.

[Hesham Amin]

search the forum for your problem.. a similer problem was post in the last month as i recall.. I think there were no direct way .. you must create the ntext column .. copy all data form the old text column to the new one .. and drop the old column..

[Mike Dimmick]

ALTER TABLE tbl ALTER COLUMN col ntext

I think that ought to work, but I'm not completely sure. Stability. What an interesting concept. -- Chris Maunder