Error: Cannot alter 'col_refs' because it is 'ntext'
Posted on 2006-07-07
I am running my company's utility that is upgrading my database. On one of the steps, the utility fails saying that it cannot alter column because it is ntext. I tried manually changing this datatype and rerunning the utility only to face the same error. Also noted that the rowsize exceeds the maximum number of bytes. An insert or update will fail if the resulting row length exceeds 8060 bytes. I have run this utility before with no problems and had it change the table datatypes on the same table. Any ideas greatly appreciated.