Post reply

Table Alter

  • September 9, 2009 at 10:41 pm

    #385337

    Hi All,

    Can we alter a table which is in replication ?

    I know to alter the table by dropping that table from replication, then alter the table then add it again to the replication.

    But can we alter that table without dropping it from replication

    Thank You

    Thank You.

    Regards,
    Raghavender Chavva

  • September 10, 2009 at 12:09 am

    #1051578

    AFAIK, Yes you can alter table in sql 2005 and the change should be replicated to the subscriber.


    Pradeep Singh

  • September 10, 2009 at 12:20 pm

    #1051872

    ps (9/10/2009)

    AFAIK, Yes you can alter table in sql 2005 and the change should be replicated to the subscriber.

    You cannot do all kinds of Alter table statements when the table is replicated. Almost all are supported

    You cannot alter a primary key when the replication is transactional.

    Adding an identity column can cause problems

    Altering or dropping identity columns managed by replication is not supported

    -Roy

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply