Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

sending data bigger then 64K

  
   Database Help (Home) -> Replication RSS
Next:  loop between 2 datetime field values  
Author Message
Roy Goldhammer

External


Since: Mar 06, 2008
Posts: 47



(Msg. 1) Posted: Sun Dec 20, 2009 9:25 am
Post subject: sending data bigger then 64K
Archived from groups: microsoft>public>sqlserver>replication (more info?)
hello there

I have a transactional replication which transfare data from two different
serves on different location.

The last data on publisher were nvarchar of 36K. when i enter the data i got
an error: Length of LOB data (68836) to be replicated exceeds configured
maximum 65536.
The statement has been terminated.

is there a way to solve it?

any help would be useful.

 >> Stay informed about: sending data bigger then 64K 
Back to top
Login to vote
Paul Ibison

External


Since: Nov 21, 2009
Posts: 4



(Msg. 2) Posted: Sun Dec 20, 2009 9:25 am
Post subject: Re: sending data bigger then 64K [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Hi Roy - here you go:
http://technet.microsoft.com/en-us/library/ms186225.aspx
HTH,
Paul Ibison

 >> Stay informed about: sending data bigger then 64K 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Real Time Data - Our company is having issues with reporting on real time data. We are using SQL Server Reporting Services and SQL Server 2005, our reports are generated from a Datawarehouse that is poplated using replication. Difficulties we are running into is,..

SQLMerge Control - missing data - I noticed that the MergeControl only replicates 5000 rows and stops. I have well over 20,000 rows of data that it should be picking up during the first run. When I run this code the second time, it picks up another 5000 rows. I have to run it..

Merge Replication - Deleting Data - Hi all, I have a problem with data rows in a header table vanishing without a trace. The header record has related detail records with related FK constraints (not enforce relationship with replication) The header record also has a link to another detail...

Publishing data while using same server as distributor - Hi all, I am trying to publish data making the same server as Distributor while using the wizard it says i am using "sa" account and the server cannot be used as a distributor if i use "sa" account,how do i go around this? do i n...

Merge replication - missing data - Hi all, I've been using Merge replication with SQL Server 2000 for about 3 years now with little problem, but over the past month have noticed that some data records that have successfully replicated to all subscribers have gone missing from the..
   Database Help (Home) -> Replication All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]