Home Forums SQL Server 2005 SS2K5 Replication Remove a column in an article from Replication without reinitializing the replication RE: Remove a column in an article from Replication without reinitializing the replication

  • June 5, 2013 at 8:08 pm

    #1621578

    brad.corbin (6/5/2013)

    This is an older question, but I wanted to add a reply, I don't think the above answers are what you are looking for.

    To remove a column from replication without doing a snapshot of the entire publication, remove the article from the subscription, then add it back in, checking only the appropriate columns.

    Then run the snapshot job (without re-initializing the entire subscription), and it should push a new snapshot copy of just that one article.

    Brad,

    Can't we run ALTER TABLE...DROP COLUMN to remove the column from the table?

    Could you please explain how to run the snapshot job without re-initializing the entire subscription? Because everytime I run the snapshot job manually, it creates a snapshot of alll the articles.

    Thanks,

    Sunny.