Replication Error:The query processor could not...

• ajithmg

  SSC Rookie

  Points: 28

  More actions

  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

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  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?

• ajithmg

  SSC Rookie

  Points: 28

  More actions

  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?

  ---

• Norberto Santin

  SSC Enthusiast

  Points: 109

  More actions

  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