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?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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment