Can we alter a table that is a part of a transactional replication.

I've a table that is published as an article in a transactional replication. I must alter the table to change the data type of some columns from int to float and float to money.

alter table command result in a failure saying that can't alter the table as the table is a part of replication.

alternatively i went to the publication to alter the column but it is allowing me to only add or remove a column.

I don't want to take the risk to remove the subscription as the data is very critical.

please some one give me a feasible and effecient way to do that.

Its urgent????

punkaj

__________________
punkaj