Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    Mars
    Posts
    115

    Unanswered: modify replication job

    Hi,
    sql server 7

    i have a replication job going on for one particular table from one server to another
    now i have added two new columns in source and replication works fine.
    once i add these two new columns in destination the replication is failing.

    i went to properties of the publisher and select the filter columns where i can find all the columns checked except the two new columns when i try to select these two its not responding pls help me in this.

    pls help me in modifying this replication.

    TIA
    hastal

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Use sp_repladdcolumn and sp_repldropcolumn for changing structure of published table. All changes will be applied for subscribers automaticaly or after restarting agent.

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    As you're using SQL 7 and any schema changes requires the replication to be refresh from scratch, means drop and recreate.

    SQL 2K has capability of taking schema changes without recreation.

    HTH
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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