Cannot alter tabe from merge subscriber

• jan.dekkers

  Grasshopper

  Points: 10

  More actions

  September 15, 2014 at 2:34 pm

  #397347

  Hi, I have a merge replicated setup with 1 publisher and 3 subscribers. Recently I added a column:

  *Take article out of replication

  *Run Snapshot

  DSPrevWage Varchar(1) to one of the tables but on 1 subscriber it was set to DSPrevWage Varchar(50) by mistake

  *Put article back into replication

  *Run Snapshot

  I didn't get any errors and the replication did run fine for a few days until last night when the replication monitor show the error. To correct this I:

  *Take article out of replication

  *Run Snapshot

  On the subscriber with the error I corrected DSPrevWage Varchar(50) TO DSPrevWage Varchar(1) and when saving the table I get:

  - Unable to modify table.

  Cannot drop the table 'dbo.AMS_Case' because it is being used for replication

  Now I guess that this subscriber still thinks its in replication although the article is removed from replication and a snapshot has been run, how do I correct this ?

  Jan