Hi,

I used Microsoft SQL Server 2000 to configure merge replication.I had two servers as publishers and one server as subscriber.Previously I had 9 articles in a publication. However, I wanted to have 8 articles only and therefore what I did is :

1) Stop synchronising.
2) Delete publication in 'Create and Manage Publication'.
3) Create back the publication with 8 articles only.

I re-created publications for 12 databases but only one failed.
After re-creating the publication, I got an error message says
"The process could not drop one or more tables because the the tables are used by other publications."
Error number : -2147200976

I tried deleting and creating publications again but failed with same error message.

Anyone have any idea what cause this and how can I solve this?Thanks.