Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 column not updating

Author  Topic 

bucsnet
Starting Member

1 Post

Posted - 2006-12-20 : 15:59:29
I'm hoping someone can help.

I had to change the size of a varchar column that is being replicated. I created a new column, copied the data into that column from the old one and dropped the old column.

this all worked fine, but now that column will not replicate from the subscriber to the publisher. so if a user changes the data and then synchronizes the data does not get updated, but if I change the data on the publisher those changes are replicated to the subscribers. I cannot find anything information on this. Please help.

Also, if I dropped the publication and recreated it would that wipe out changes on the subscriber that haven't been sync'd yet or would it not be a problem?

monty
Posting Yak Master

130 Posts

Posted - 2006-12-20 : 23:14:10
which version of sql server ru using? also which type of replication is that ur using?

its me monty
Go to Top of Page
   

- Advertisement -