I have have running sybase database and particular column in a table has started overflowing [data type smallint]. I have to alter the table column to int. It is a huge table. what is the best strategy to do this, so that I will have minimum downtime if any.

thanks a lot.

sanghmitra