urgent -sql server transactional replication-issues with text data

• shaili

  Right there with Babe

  Points: 753

  More actions

  July 1, 2010 at 7:30 am

  #157048

  Hello,

  I have transactional replication set up. Publisher/distributor server is 2005 Enterprise version but database is in 2000 compatibility mode. Subscriber is sql server 2005 and is in 2005 compatibility mode.

  We have several tables with text columns on publisher. When replicated, text data string is not entirely replicated. The data gets chopped in the middle leaving publisher and subscriber out of sync.

  Are there any known issues with replicating text data with sql server 2005/2000?

  We have task in funnel to change these fields to varchar(max). If there are issues with replicatiing text data, we have to act on that quickly.

  Please let me know if you have any knowledge.

  PS Subscriber is non-updateable.

  Thanks,

  Shaili

• G.R.Prithiviraj Kulasingham

  SSCarpal Tunnel

  Points: 4105

  More actions

  July 1, 2010 at 9:24 am

  #1187729

  Try this:

  sp_configure 'max text repl size', 2097152

  GO

  RECONFIGURE WITH OVERRIDE

  GO

  This will set the maximum amount of data that could be transferred to 2 MB The default is 64 kb,

  hope this helps

  Cheers,
  Prithiviraj Kulasingham

  http://preethiviraj.blogspot.com/

• David Benoit

  SSC-Dedicated

  Points: 34562

  More actions

  July 1, 2010 at 9:33 am

  #1187738

  Some more information on this can be found here. This is 2000 related but still applicable.

  David

  @SQLTentmaker

  “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot