2005 replication alter table ?

Hi There

I am using transactional replication in 2005.

I am used to 2000 where if a column was added or changed to had to use sp's to do this and for altering a column you had to drop the subscription change and add back etc.

With 2005 is this fully handled by ALTER TABLE, can i safely make any meta data changes to an article with ALTER TABLE and the changes will progate to subscribers no problem.

Or are there limitations are there certain changes to articles that must still be done through sp's?

Thanx

Hi,

SQL 2005 nows supports to use ALTER TABLE directly to publication database to change the schema. For the things to consider, please see the following documents in BOL: "Making schema changes on publication database" http://msdn2.microsoft.com/en-us/library/ms151870.aspx.

As documented in the link, one scenario that you still need sp_repladdcolumn and sp_repldropcolumn is republishing. For others, you can just use ALTER TABLE.

Peng