all groups > sql server replication > august 2003 >
You're in the

sql server replication

group:

Problems with merge replication


Problems with merge replication maria
8/26/2003 1:25:13 PM
sql server replication:
I have two servers running sql server2000. Server1 is a
publisher/distributor and server2 is a subscriber. I
configured a merge replication with pull subscription.

When i configure the replication and filters, all was find
but when i try to send the first snapshot to the
subscriber it reports this error:

"create table #belong_agent_-1853981062 (tablenick int NOT
NULL, rowguid uniqueidentifier NOT NULL,generation int
NULL, lineage varbinary(255) NULL, colv varbinary(2048)
NULL)

Failed to enumerate changes in the filtered articles.
(Source: Merge Replication Provider (Agent); Error
number: -2147200925)
-----------------------------------------------------------
----------------------------------------------------
Line 1: Incorrect syntax near '-'.
(Source: SDIVINFSQL (Data source); Error number: 170)"

I have configured 3 merge publication that has the same
articles. The differences are the filters.

I already delete the publication and subscription and
recreate it and after that i get the same error.

What do you recommend me to do, to fix the problem???

RE: Problems with merge replication gopal NO[at]SPAM online.microsoft.net
8/27/2003 2:41:45 AM
If you reboot the publisher and then run the agent the agent will continue
to run for apporximately another 29 days before you see this
problem again. We have a fix for this issue, please call MS support so that
we can provide you with the fix.

Thanks
Gopal
AddThis Social Bookmark Button