urgent -sql server transactional replication-issues with text data

  • shaili

    Right there with Babe

    Points: 753

    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: 4104

    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

    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

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply