October 4, 2006 at 6:14 pm
i have replication set up on the system.
i cant change the column names,or change datatype.
wanted to change the name of the column in publisher DB
gives the error:
Cannot rename the table because it is published for replication.
any suggestions wht to do
tx
October 5, 2006 at 1:13 am
The following sp will solve your problem, but it is always recommended to drop replication, alter the table then reconfigure the replication.
exec sp_repladdcolumn @source_object,@column,@typetext,@publication_to_add
------------
Prakash Sawant
http://psawant.blogspot.com
October 6, 2006 at 8:42 am
This question was posted on the 2005 forum. There are very different behaviours between 2000 and 2005 when it comes to DDL and replication.
Please, do not double post and make sure that the release you are talking about correspond to the appropriate forum
Cheers,
* Noel
October 6, 2006 at 8:45 am
You may try to reinitialize the snapshot agent.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply