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 |
|
uxphreak
Starting Member
38 Posts |
 Posted - 2005-05-13 : 14:51:04
|
| Hello,I have two databases which are being replicated using merge replication. If I run sp_helpmergesubscription on both db's, I get a list of all subscribers, but I also get the following:Server: Msg 20026, Level 11, State 1, Procedure sp_MSenum_merge_agent_properties, Line 28The publication '%' does not exist.What is this and how do I remove this publication?D |
|
|
tomy74
Starting Member
32 Posts |
Posted - 2005-05-16 : 03:55:54
|
| Hi,First of all , can you check the sp_helpmergesubscription parameters , should be like that :sp_helpmergesubscription [ [ @publication =] 'publication'] [ , [ @subscriber =] 'subscriber'] [ , [ @subscriber_db =] 'subscriber_db'] [ , [ @publisher =] 'publisher'] [ , [ @publisher_db =] 'publisher_db'] [ , [ @subscription_type =] 'subscription_type'] [ , [ @found =] 'found' OUTPUT]for more info : http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_repl2_70oe.aspand it's better to share your code , maybe i can help u more .To drop a merge publication you can use the following commad : sp_dropmergepublicationfor more info :How to manually remove a replication in SQL Server 2000http://support.microsoft.com/default.aspx?scid=kb;EN-US;324401ThanksTarek |
 |
|
|
|
|
|
|
|
Merge Replication: Publication does not exist