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
Friday, February 24, 2012
Error trying to do transactional replication on a long text column
Labels:
column,
columnerror,
database,
error,
following,
message,
microsoft,
mysql,
oracle,
process,
replication,
server,
sql,
table,
text,
transactional,
transactionalreplication
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment