-
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.