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 - 2005-05-09 : 08:24:00
|
| Alan writes "I have a transactional replication set up with10 sites set up as publishers with a publication andone site with 10 pulling subscription each set up for 1 of the publication'a. They all replicate to the same database on the subscriber.I run SQL Server 2000 sp3 on windows 2003 Server at the subscriber.I run sql server 200 Standard Edition sp3 8.00.818 on Windows 2000 at the publishers.This particular set up has been running for 1 month, but onlyfor 5 day's with a recent reconfigure.One of the sites is providing us with a 8626 error which Ihave included below.I have the same collation between databases.The table providing the error has 3 text fields.I saw a reference where "If No Log option is used with WriteText and UpdateText no replication will occurr.Of course I am logging transaction's but I get the feelingthere is a param I might want to set within replicationto ensure WriteText and UpdateText commands are taking place.I am not sure where this param would be set or if it even exist.Basically I am a little stumped on this one and have not been ableto Google my way out of it.Any suggestion's or Ideas would be much appreciated.Erro Number: 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. 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. The step failed.Thanks,Alan" |
|
|
|
|
|
|
|
Replication Error 8626