sql server replication: I have 2 databases with merge replication set up and a number of tables that
have 2 integer fields (one - identity) , a varchar (8000) string field and a
rowguid column. When clients are connected to publisher, and the length of
the string inserted into a table of above mentioned structure reaches 8000
characters, the change gets replicated to the subscriber without any errors.
The moment a client gets connected to a subscriber and performs the same
insert operation, replication generates an error:

The process could not enumerate changes at the 'Subscriber'.

(Source: Merge Replication Provider (Agent); Error number: -2147200999)

----------------------------------------------------------------------------
-----------------------------------

Cannot sort a row of size 8120, which is greater than the allowable maximum
of 8094.

(Source: ATLAS (Data source); Error number: 1540)

----------------------------------------------------------------------------
-----------------------------------

The process was successfully stopped.

(Source: Merge Replication Provider (Agent); Error number: -2147200999)



Any ideas? Any help would be greatly appreciated!



Thanks,

Marshall

Marshall,

There is a restriction for the column size to 6000 bytes when using Merge
Replication. The reason is because of conflict tables that are created with
the same image of your data table + some additional columns. The space
reserved for those additional columns therefore causes the limitations
Look in Books Online in the section "Planning for Application Development"
for more info.

Also looks like you will have to either redesign your table(s) or limit the
amount of data to 6000 bytes less the sum of sizes of the other columns.

Raj Moloye