SQL Server Performance

Replication Question

Discussion in 'Performance Tuning for SQL Server Replication' started by photura, May 11, 2006.

  1. photura New Member

    How do I remove a table from being published in order to change the column name and how would I add it back without breaking anything.
    photura, May 11, 2006
    #2

  2. satya Moderator

    http://www.replicationanswers.com/AddColumn.asp

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, May 11, 2006
    #2

  3. photura New Member

    The article was very informative.

    However, what's confusing me is that the column being renamed is a PK column. If I do as the article states and create a new column and drop existing column using sp_repaddcolumn will I also have to recreate the PK. If so, how. Would it be done as normal?

    Thanks.



    quote:Originally posted by satya

    http://www.replicationanswers.com/AddColumn.asp

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    photura, May 11, 2006
    #2

  4. satya Moderator

    Script to create the PK and apply there after.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, May 12, 2006
    #2

Share This Page