The SQL Server 2005 process was unable to the table "dbo". " XXX "" For bulk copy

Error message displayed:

Error message:

The process was unable to the table "dbo". " Company "" For bulk copy. (Source: MSSQL_REPL, Error number: mssql_repl20037)

Getting Help: http://help/MSSQL_REPL20037

Batch Send failed

The length of text used to bulk copy text, ntext, or image data is missing in the data stream. (Source: MSSQLSERVER, error number: 4813)

Getting Help: http://help/4813

To obtain a detailed description of the error file for the error that was encountered when initializing the subscription table, perform the bcp command shown below. For more information about the bcp utility and the options it supports, see BOL. (Source: MSSQLSERVER, error number: 20253)

Getting Help: http://help/20253

bcp "XXX". " dbo "." Company ' in ' d:repldatauncwin-39lldblgoah_cr173com_17320131209110101company_2.bcp '-e ' errorfile '-t ' n

Getting Help: http://help/20253

Solution:

1, the server-> properties-> Advanced will be the largest text copy size larger. Minimum plus two 0

(It's not a good thing to do)

After the investigation to this table has a very long and special HTML tag class/<&%|^ special characters, remove the column on the successful release.

But in practice this exclusion is very difficult, you do not know which record has a special character.

Later, all character sets are converted to Unicode to resolve.

Adjust all non-Unicode (Varchar/char/text) type fields to Unicode (Nvarchar/nchar/ntext) type.

It seems to be better to use the Unicode character set when you create a new table later