Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    China
    Posts
    2

    Red face Unanswered: Replication Error of MS SQL server2k

    Distribution Agents come with a error and stop between two SQL2000 server.
    The error messages is:

    The query processor could not produce a query plan from the optimizer
    because a query cannot update a text, ntext, or image column and a
    clustering key at the same time. (Source: Some Server (Data source); Error number:
    8629)

    How can I fix it?

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621

    Re: Replication Error of MS SQL server2k

    Is it transactional replication?
    If yes - and you are using Identity fields (with not for replication) then check prsp_MSupd_**** stored procedures on subscriber and remove updating Identity field.

Posting Permissions

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