Post reply

Add table back to replication

  • August 21, 2007 at 1:03 pm

    #91224

    I'm a developer not a DBA, so I know very little things about replication. Nevertheless, I had to modify the length of a column in a table that was being replicated.

    I used the stored procedures sp_repladdcolumn and sp_repldropcolumn to achieve this task.

    The problem is that the table is not being replicated anymore. I've checked the replication monitor but I don't get any error messages. The rest of the tables are being replicated OK.

    I'm using SQL2K on both the publisher and the suscriber.

    How can I add the table back to replication? What/where should I check?

     I'd appreciate any help on this.

  • August 21, 2007 at 1:50 pm

    #728418

    Read the remarks of sp_repladdcolumn and see if it applies. I think your issue lies in the remote table, did you adjust the column there as well. If nothing else try reintializing the subscription (but if this is a large table you might want to try changing the remote table to match as far as the column length of the changed column)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply