Convert from varchar to Nvarchar SQLServer 2008

Question

I have a table has a coulmn of type varchar I need to convert it to Nvarchar but it shows an error that I have to drop the table and recreate it :) any advice !!

Answer 1

Does this not work:

ALTER TABLE my_table ALTER COLUMN my_varchar_column NVARCHAR(32)