SQL Server Performance

Droping added column on replication table

Discussion in 'SQL Server 2005 Replication' started by jogin malathi, Aug 26, 2008.

  1. jogin malathi New Member

    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.
  2. dineshasanka Moderator

Share This Page