SQL Server Performance

Replicate ntext text image in Transaction Replicat

Discussion in 'SQL Server 2005 Replication' started by holger9938, May 16, 2007.

  1. holger9938 New Member

    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
  2. satya Moderator

    Post the exact error you are getting.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    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.
  3. MohammedU New Member


    Check BOL topic "Updatable Subscriptions for Transactional Replication"
    http://msdn2.microsoft.com/en-us/library/ms151718.aspx

    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
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

Share This Page