Hi... What can someone correct if i am going in wrong way steps i am following to drop added column on replication table. Step1: Drop the subsribers of Article as exec sp_dropsubscription Step2:Remove the Article (Table) from the Publication as exec sp_droparticle Step3: Drop column manually. Step4:Adding Table back to replication. This is the case when i am not using sp_repladdcolumn to add column.
In SQL Server 2005, DDL replication is available. http://www.sql-server-performance.com/articles/dba/ddl_replication_2000_2005_p1.aspx