Field size too large error

[Argirop]

While applying the snapshot to the subscriber, I get an error saying

The process could not bulk copy into table '"dbo"."MSmerge_contents"'

and then

"Field size too large"

Can some one give an explanation about this error?

The publisher is SQL Server 2005 Std (SP2), the publication is partitioned
(via HOST_NAME), the subscriber is SQL 2005 Express SP2 and the subscription
is merge pull.

Thanks in advance

[Paul Ibison]

Please check your publication - there's anecdotal evidence that removing
-UseInProcLoader will fix this problem. This makes sense to me if you have
XML which you are replicating, but otherwise I don't see the relevance. Still
- if you have this set then please try without and tell us how it goes.
HTH,
Paul Ibison (www.replicationanswers.com)

[JDS]

On Aug 27, 12:54 pm, Argirop <Argi...@discussions.microsoft.com>
wrote:

I have come across the same error after making changes on the
publisher and/or reinstalling the database on the client.
Unfortunately, the error message is not very informative. In this case
I found that dropping the subscription on the server
(sp_dropmergesubscription) and regenerating the snapshot resolved the
issue. At the subscriber, I also reinitialised the subscription. I
don't know if this is the same in your case but I hope it may provide
some help.

Jeremy