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.