sql server replication: Help! Got an error while do the replication update -- sql server replication

Re: Help! Got an error while do the replication update

Hilary Cotter
10/28/2004 8:03:14 AM

sql server replication: can you post your schema here for the problem table? Also do you recall what
update/insert/delete caused this problem?

Perhaps try to restart your agent and log according to:

http://support.microsoft.com/default.aspx?scid=kb;en-us;312292

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

[quoted text, click to view]

Help! Got an error while do the replication update

Madstan
10/28/2004 11:53:10 AM

Dear all,

I got the following error while doing the replication in updating the date,
I found that a column's datatype is NTEXT, but i have other table also are
have columns set to NTEXT datatype and it works.

Does anyone have any idea on it?

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