August 21, 2007 at 1:03 pm
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
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