• [font="Verdana"]What is the error you are facing , you can alter the Table if there is no index exists on the column you are altering and if any index exists the only change it will allow is increasing the datatype limit .

    So if you are changing Datatype varchrar(200) to nvarchar(200) it will fail and if you run varchar(100) to varchar(200) it will successfully execute .

    Please post error ! [/font]