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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-04-20 : 07:49:01
|
| Vinod writes "When I'm testing merge replication on Database with PK, FK Relationships, I get the following error: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)Please suggest me the solution ASAP.Any One have any idea about it?" |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-04-20 : 08:07:28
|
yes, as the error is telling you,you can't re-publish articles/tables that are subscribing already,either you delete the existing subscription or don't continue with the merge replication  --------------------keeping it simple... |
 |
|
|
|
|
|
Source: Merge Replication Provider Error number: -2147200976