Post reply

Alter stored procedures and tables while replication is running

  • May 24, 2009 at 10:03 pm

    #95648

    Hello to ALL!

    I am just new to replication.

    I just want to know if can I still alter my stored procedures, tables, views and functions after a successful replication?

    By the way I am using SQL Server 2000.

    Many Thanks:D

  • May 24, 2009 at 10:19 pm

    #999558

    With SQL 2000, you have limitation on what you can change.

    For tables, you can add or remove columns PROVIDED THAT you use the stored proc sp_repladdcolumn and sp_repldropcolumn. If you use ALTER TABLE to do the change, replication will not notice the change.

    For sprocs etc, if they are part of a snapshot publication, they will be scripted each time the snapshot runs. Hence, changes will propogate to the subscriber. If you are using any other replication model, the changes will not be noticed by replication.

  • June 16, 2009 at 7:36 am

    #1010178

    I agree..

    It does depend on what is replicated and and what needs to be changed.

    An ALTER TABLE command needs to drop and recreate the table and this is not possible if the table is being transactionally replicated in SQL2000.

    I guess it also depends on what type of replication you are using

    Regards

    Graeme

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

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