replication:cant add columns
-
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
-
You should really read BOL on requirements and restrictions when using replication.
Essentially to alter a replicated table remove it from the publication, make changes , and add it back.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/ -
>> Essentially to alter a replicated table remove it from the publication, make changes , and add it back. <<
Not true anymore, in 2005 you can use DDL and replication takes care of the rest
Cheers,
* Noel -
agreed - with peer to peer - assumed this was not the case otherwise the Q would not have been asked ^^
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/ -
I have done it with Transactional, Not with Peer-to-Peer.
By the way I have changed the datatype, not the name!!
Cheers,
* Noel -
which DD shld be used?
tx for the reply
-
Alter table
Alter column new_datatype
just make sure your types are implicitly convertible.
Cheers,
* Noel
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply