Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-02-27 : 12:04:50
|
| Simon writes "I'm trying to replicate (transaction) some tables including one that had a clustered primary key and some text columns. The error was:"8629Message: 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."Eventually I made the primary key non-clustered and tried again and got the following error:"8626Message: Only text pointers are allowed in work tables, never text, ntext, or image columns. The query processor produced a query plan that required a text, ntext, or image column in a work table."After looking at several articles, I tried adding the "-NoTextInitOnSync" to the Distribution agent (it's not an option on the snapshot agent) but this didn't fix it.I've just converted from merge to transactional and apparantly there was no problem when it was a Merge (before my time here).This happens for both snapshot & distribution agent." |
|
|
|
|
|
Errors 8626 & 8629 when replicating text columns