September 15, 2014 at 2:34 pm
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
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply