"Dean" <dpichotto@cse-insurance.com> wrote in message
news:1120071435.407646.302670@g49g2000cwa.googlegroups.com...
> After working for over a year, one of our snapshot replication
> distributions now fails with the following error:
>
> The process could not bulk copy into table '"texttab"'.
>
> Expected the text length in data stream for bulk copy of text, ntext,
> or image data.
> (Source: DESTINATION_SERVER (Data source); Error number: 4813)
>
> Function sequence error
> (Source: ODBC Driver Manager (ODBC); Error number: S1010)
>
> The last column of the table in error is type "text". If we lower the
> number of the "BCPBatchSize" in the distribution agent profile, more
> rows get copied before the error occurs - but there are too many other
> very large tables in the snapshot to use that as a go-around.
> As suggested in a previous post, we cannot change the table structure
> because it is a third-party developed product.
> When we use the -UseInProcLoader option in the dist agent, it creates
> another error.
> We're running SQL Server 2000 8.00.760
> Thanks for any ideas.
>