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.
  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.
  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.
  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.

Share This Page