Results 1 to 2 of 2

Thread: Schema Changes

  1. #1
    Anjan Guest

    Schema Changes

    SQL 7.0 SP3 replicating a database from a publisher to a SQL 7.0 SP 3 subscriber.

    Is there a way to change publisher schema without stopping the replication? Example Add a 'bit' column to a table with default of '0'.


  2. #2
    Ray Miao Guest

    Schema Changes (reply)

    No for sql7, yes for sql2k.


    ------------
    Anjan at 6/25/01 10:11:05 AM

    SQL 7.0 SP3 replicating a database from a publisher to a SQL 7.0 SP 3 subscriber.

    Is there a way to change publisher schema without stopping the replication? Example Add a 'bit' column to a table with default of '0'.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •