Merge Replication

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.

You have two publishers or one publisher?. Is there any other publication on the same server?.

Double check if the db has multiple publications.

I have two publishers. There are other publications on the same server but on different db. I've checked the db but it did not has multiple publications.

Revome replication for that db again then check with 'sp_dboption db_name', ensure there's no 'published' in result.