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.
| Author |
Topic |
|
rajdaksha
Aged Yak Warrior
595 Posts |
 Posted - 2009-07-17 : 04:26:54
|
| HiWe have replication setup like this...SERVER A Table ASERVER B Table A (this article is replicated from Server A)SERVER C Table C (this article is replicated from Server B)So those three servers are running fine…If I want to change the column datatype or I want to increase the datatype length.How I can do... Please put yours valuable proposal -------------------------R.. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-17 : 04:35:03
|
| Change it on the publisher (ServerA) and push out a new snapshot.Here is a tutorial for you:http://www.sqlservercentral.com/articles/Replication/alteringacolumnonareplicatedtable/1666/ |
 |
|
|
rajdaksha
Aged Yak Warrior
595 Posts |
Posted - 2009-07-17 : 04:56:04
|
| Thanks..RickD-------------------------R.. |
|
|
|
|
|
|
DATATYPE CHANGE