Groups | Blog | Home
all groups > sql server replication > march 2006 >

sql server replication : How do I Change size of a column which is involved in a replicatio


Mathew
3/28/2006 9:09:01 AM
Hello,
Does anybody know a sp like Sp_repladdcolumn to change a column size without
having to bring down the replication.

Thanks in advance,

Mathew
Vijay TS
3/28/2006 12:39:02 PM
In SQL 2000 there is no way to change a column without bringing down the
replication. In SQL2005 you can do "alter table" and it will be replicated
to subscribers.
--
“This posting is provided "AS IS" with no warranties, and confers no rights.”


[quoted text, click to view]
Paul Ibison
3/29/2006 12:00:00 AM
Matthew,
here are some workarounds in SQl Server 2000 :
http://www.replicationanswers.com/AddColumn.asp
In SQL Server 2005 this comes out of the box:
http://www.replicationanswers.com/AlterSchema2005.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

AddThis Social Bookmark Button