Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 merging error

Author  Topic 

mikhailb
Starting Member

3 Posts

Posted - 2005-04-08 : 17:29:16
When I'm testing merge replication on two dummy tables without any relationships, it works fine. However, when i try to merge tables with relationships from pubs database (for testing purposes), I get the following error:

The process could not drop one or more tables because the tables are being used by other publications.

The process could not drop one or more tables because the tables are being used by other publications.
(Source: Merge Replication Provider (Agent); Error number: -2147200976)
----------------------------------------------------------------------

any ideas?


   

- Advertisement -