Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Posts
    55

    Unanswered: Replication and table/SP change?

    I build a table and stored procedure replication between 2 database.
    seems when I want to change the stored procedure / or Table, the replication still hold the objects and won't let me to do.

    is that the only way drop the replication( publisher/disbtribution/subscrib)
    make the table / store procedure change, than rebuild replication again?? any other short cut??

    GUYANG

  2. #2
    Join Date
    Jan 2003
    Location
    Nottinghamshire, UK
    Posts
    364
    Hi

    SQL2K has a lot of improvements when it comes to changing the schema of replicated tables.

    What Ver SQLServer R U Using & what types of replication merge/snapshot etc

    Changes to tables must be done through the publication properties in 2K Enterprise Manager or using the system Stored Procedures provided for the purpose.

    Stored Procedures can only be edited at the publisher U Can't merge changes to them - Urghhh What a thought. - U can Snapshot these out to subscribers.

    If U R Using SQL7 you are out of Luck

    GW
    "Everything should be made as simple as possible, but not simpler." - Albert Einstein
    "Everything should be made as complex as possible, so I look Cleverer." - Application Developer

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Valid references by GW, for any schema changes on the source table, its advised to redefine the replication settings once its finished.
    --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
  •