Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002

    Unanswered: Transactional Replication Error: Updatable Subscriptions

    I'm receiving this error when attempting to insert a record into the Subscriber.

    Microsoft OLE DB Provider for SQL Server error '80040e14'
    Updatable Subscriptions: The text/ntext/image values inserted at Subscriber will be NULL.

    The record is created at the publisher but the text fields are set to NULL. All other fields are populated correctly.

    Inserting at the Publisher works perfectly.

    Running SQL Server 2000 SP2/Windows 2000 SP2, Transactional Replication, Publisher/Distributor on same machine with one Subscriber. Using the Immediate/Queued option as well. Identity fields are managed by the publication.
    Last edited by jweb; 12-03-02 at 15:42.

  2. #2
    Join Date
    Apr 2003

    Re: Transactional Replication Error: Updatable Subscriptions

    Updating text and image columns at the subscriber is not supported for transactional replication with queued updatable subscriptions.

  3. #3
    Join Date
    Aug 2002
    Instead, you could partition the text and image columns into a separate table and modify the two tables within a transaction.
    --Satya SKJ
    Microsoft SQL Server MVP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts