Post reply

Replication Error:The query processor could not...

  • April 23, 2003 at 8:45 am

    #80002

    Hi,

    I am running SQL 2K SP3 on a WIN2K machine with SP3. I

    have set transactional data replication(as distributor) on

    this Server. The subscriber Server is also running the

    same softwares. I am getting the following error,

    "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."

    Apparently the Books online has the reference to this

    error.

    Is there any way around for this. Your help will be much

    appreciated.

    Thanks in advance.

    Best Regards,

    Ajith

  • April 23, 2003 at 3:04 pm

    #455098

    did you recieved this error in the distribution agent? Are you replicating changes with customs stored procedures? Does the error shows, wich stored procedure failed to execute?

  • April 24, 2003 at 2:46 am

    #455135

    Yes, received the error in the distribution agent. I am not replicating any custom stored procedures. The error was pointing to one of the SP's which is created by replication setup for updating one of the tables marked for replication. There is push subscription enabled for replicating. Hope that helps.

    Thanks.

    quote:

    did you recieved this error in the distribution agent? Are you replicating changes with customs stored procedures? Does the error shows, wich stored procedure failed to execute?

  • January 25, 2011 at 2:45 pm

    #1278205

    did you resolve the problem?

    I having the same problem with a transactional replication that was running fine..

    Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply