Replicate ntext text image in Transaction Replicat | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Replicate ntext text image in Transaction Replicat

Hi! i have a problem with my replication. I have two SQL 2005 SP2 Server and want to use the transaction replication with updateable subscriber. Now the problem is that i can do any changes on the master server. But if i want to change a record on the subscriber which contains a ntext, text, oder image column – then i geht the error that the field will be NULL on the master. Is there any solution to fix this problem? I dont wan`t to change the datatype vom ntext to varchar(max) !! greetings Holger

Post the exact error you are getting. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Check BOL topic "Updatable Subscriptions for Transactional Replication" Subscribers cannot update or insert text, ntext or image values because it is not possible to read from the inserted or deleted tables inside the replication change-tracking triggers. Similarly, Subscribers cannot update or insert text or image values using WRITETEXT or UPDATETEXT because the data is overwritten by the Publisher. Instead, you could partition the text and image columns into a separate table and modify the two tables within a transaction. To update large objects at a Subscriber, use the data types varchar(max), nvarchar(max), varbinary(max) instead of text, ntext, and image data types, respectively. MohammedU.
Moderator All postings are provided “AS IS” with no warranties for accuracy.