dbTalk Databases Forums  

Does Transactional replication truncate blob content ?

microsoft.public.sqlserver.replication microsoft.public.sqlserver.replication


Discuss Does Transactional replication truncate blob content ? in the microsoft.public.sqlserver.replication forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Wilker Bezerra
 
Posts: n/a

Default Does Transactional replication truncate blob content ? - 10-30-2009 , 01:25 PM






Hi All.

I have a table published using transactional replication (Sql2k+Sp4), and in
this table I have a blob column.

I update this table/field with no problem on publisher.

But, the content of this column arrives truncated on subscriber.

I can solve this problem changing to merge, but I will need to recreate
publication.

How can I avoid this truncating data to subscriber ?

Is there any know configuration ? I searched for blob size, package size,
but nothing helps me.

thanks

Reply With Quote
  #2  
Old   
Paul Ibison
 
Posts: n/a

Default RE: Does Transactional replication truncate blob content ? - 11-09-2009 , 06:58 AM






Have a look at max text repl size in sp_configure...
HTH,
Paul Ibison

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.