Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Merge replication problem

Status
Not open for further replies.
rushdib

rushdib

Programmer
Jun 12, 2001
203
US
Hello,
We had a merge replicaton happening between SQL Server 1 and SQL Server 2. Both servers act as distributors/Publishers. I had to change one set of merge replication pulication from SQL Server 1 and SQL Server 2. So I removed the publication on the Sql Server 1 and tried to start the pulication on SQL Server 2 but it's not allowing me to do that. It says there are still subscriptions on SQL Server 2. I cannot see any subscriptions and i even tried to delete the subscriptions using sp_deletemergesubscriptions command. It couldn't find any subscriptions. Can someone please help me? This is critical situation for us.

Thanks in advance,

Rushdi
 
Status
Not open for further replies.

Similar threads

griffitd
  • Locked
  • Question
SQL 2005 replication hanging
Replies
0
Views
98
griffitd
griffitd
Kliot
  • Locked
  • Question
Sql Server 2008 Replication Agent message code 20084
Replies
5
Views
287
Kliot
Kliot
bluto99
  • Locked
  • Question
Replication snapshot retention
Replies
1
Views
90
yelworcm
yelworcm
griffitd
  • Locked
  • Question
replication question
Replies
0
Views
77
griffitd
griffitd
BobRodes
  • Locked
  • Question
Permissions problem executing stored procedure
Replies
5
Views
193
BobRodes
BobRodes

Part and Inventory Search

Sponsor

Back
Top