Post reply

Temporarily disable replication

  • August 10, 2005 at 9:50 am

    #165578

    Is there a way I can temporarily turn off replication so that I can move a database? Thanks.

    -Al

  • August 10, 2005 at 9:51 am

    #581100

    Depends on what your doing.

    if you move the publisher to a different server, then all your subscribers will be messed up. Not sure how to change publisher at subscriber.

     

  • August 12, 2005 at 1:05 am

    #581661

    H!!,

       Suppose if you are intending to add a column to a replicated table you can make use of this stored procedure

    sp_repladdcolumn @source_object = 'authors'

    , @column = 'newcol'

    regrads,

    vinod (DBA)

    HTC Global Services

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

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