As Peter says, you can use sp_repladdcolumn. If you're using SQL Server 2005
you should use ALTER TABLE.... This'll work provided you aren't adding a PK
or identity column (see
http://www.replicationanswers.com/AlterSchema2005.asp).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Hello,

You could use sp_repladdcolumn or do this in SQL Enterprise Manager.

827960 You may not be able to add columns to a published article by using
sp_repladdcolumn
http://support.microsoft.com/default.aspx?scid=kb;EN-US;827960


Q320123 HOW TO: Add Columns in a Rollup Subscriber Topology,
<http://support.microsoft.com/support/kb/articles/q320/1/23.asp>

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================


This posting is provided "AS IS" with no warranties, and confers no rights.