Alter table in transactional Replication

I have a table that is being used in transactional replication. On publisher
side table is altered and a column is added. I would want the new column also
to be replicated.
Here is what i did-
- drop the subscription
- remove article from publication
- add back article
- modify insert update stored procedures at subscriber
- add the subscription
Is there any other way to do it as I donot want my subscription to be
dropped each time as it has some other tables that are replicated
continuously...
Regards,
Ravi
You can use sp_repladdcolumn.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
sql