sql server replication:
I have SQL Server 2000 transactional replication and it
works fine.

I needed to alter a table and add two tables to the
database and the replication article.

I delete the transaction replication subscription.

I tried to alter a table and received an error stating
that the table could be altered because it was
replicated.

What is the easiest procedure to alter or add a
replication table?

Thanks,

Mark

Mark,
to add or delete a column from a table involved in replication, you can use
sp_repladdcolumn, sp_repldropcolumn. sp_addarticle and sp_droparticle work
at the table level. These changes can be done in the replicaiton properties
GUI or in code. Changing a table using EM, when it is replicated will cause
the error message you have seen.
Regards,
Paul Ibison