October 22, 2009 at 10:41 pm
I'm Running Replication, Error Message :
The subscription to publication 'Rep' is invalid.
(Source: Merge Replication Provider (Agent); Error number: -2147201019)
can somebody help me again?
October 23, 2009 at 4:47 am
cocobi.xxx (10/22/2009)
I'm Running Replication, Error Message :The subscription to publication 'Rep' is invalid.
(Source: Merge Replication Provider (Agent); Error number: -2147201019)
can somebody help me again?
Without more information, the only option would be to re-create the subscription. do you have the subscription creation, scripted. If so recreate the subscription.
what entries do you have in the sysmergesubscriptions table
This table is stored in the publication and subscription databases
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 30, 2009 at 7:52 pm
Was there any other message with the one that you posted? I have seen a similar error very frequently with 2000 merge replication, and most of the time it is due to flaky network connections. Manually starting replication usually fixes the problem for me.
Joie Andrew
"Since 1982"
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply