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
 SQL Server Administration (2000)
 Merge replication problems

Author  Topic 

Rushdi Basir
Starting Member

1 Post

Posted - 2003-06-20 : 11:10:39
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

debug
Starting Member

29 Posts

Posted - 2003-06-23 : 04:00:52
its because of RowGuid column which gets generated as to publish so when u are trying it on the other server which already is acting as a publihser its not letting u start the replication. Its a known Bug in SQL server...please refer to Microsoft SQL server bug reports.



DU
Go to Top of Page
   

- Advertisement -