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 2005 Forums
 Replication (2005)
 Delete A Merge Replication Publication

Author  Topic 

rajantonyv
Starting Member

12 Posts

Posted - 2007-03-15 : 14:52:38
I tried to drop a merge replication publication and it is giving me an invalid object name dbo.ms_mergeagents message. I tried to drop using:

SSMS
sp_dropmergepublication
sp_replicationdboption

I got the last two from Microsoft KB article 324401. The subscription was never created because it gave another error invalid object_name msmerge_subscriptions. I can create new publications but not drop the existing ones.

Please assist...

MohammedU
Posting Yak Master

145 Posts

Posted - 2007-03-17 : 01:42:05
Did you try dropping the publication with sp_dropmergepublication procedure?
See BOL topic "sp_dropmergepublication" for details...

MohammedU
Go to Top of Page
   

- Advertisement -