Friday, February 24, 2012

Error trying to do transactional replication on a long text column

I am getting the following error message when I try to do a transactional
replication of a large table with a text column:
Error Message: The process could not bulk copy into table '"monitorResults"'.
Error Details: Expected the text length in data stream for bulk copy of
text, ntext, or image data.
(Source: IWPSQL3 (Data source); Error number: 4813)
I checked sp_configure 'max text repl size (B)' and it is much larger than
the results from: SELECT max(datalength(notes)) FROM dbo.monitorResults
Does anyone have any ideas?
Thanks!
Racer-D
does this post help?
http://groups.google.com/groups?selm...utput =gplain
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Racer-D" <RacerD@.discussions.microsoft.com> wrote in message
news:960960F3-46E7-44C6-A46F-078D6A448DD7@.microsoft.com...
> I am getting the following error message when I try to do a transactional
> replication of a large table with a text column:
> Error Message: The process could not bulk copy into table
'"monitorResults"'.
> Error Details: Expected the text length in data stream for bulk copy of
> text, ntext, or image data.
> (Source: IWPSQL3 (Data source); Error number: 4813)
> ----
--
> I checked sp_configure 'max text repl size (B)' and it is much larger than
> the results from: SELECT max(datalength(notes)) FROM dbo.monitorResults
> Does anyone have any ideas?
> Thanks!
> Racer-D

No comments:

Post a Comment