sql server replication: Hi,

I have created transactional replication with 5 publisher.I want to alter a
column defination of one of the article.Should I drop the publication and
recreate the publication or is there an easy way out

Copy the data to a holding table, Drop the column using sp_repldropcolumn,
add the new column definition using sp_repladdcolumn, and then copy the data
to the new column

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]

Please take a look at these articles:
http://www.replicationanswers.com/AddColumn.asp
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)

Thanks a lot.It worked!

[quoted text, click to view]