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

    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 16:42.

  2. #2
    Join Date
    Apr 2003
    Posts
    1

    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
    Location
    Scotland
    Posts
    1,578
    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
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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