Convert Column from Varchar to NVarchar
623758Jan 22 2009 — edited Jan 22 2009Hi Guys,
i know we cannot alter a columns datatype when there is a data. but the problem is that i would like to alter a datatype with the data in database. as there is no downtime to our server. im not sure this can be achieved, but i feel someone might have faced this kind of problem. even we cannot create new columns and then dump the data there and then delete the old columns as the data is huge.
please advice.
thanks
Fairozkhan