SQL Server process cannot bulk copy to table

Original: SQL Server process cannot bulk copy to table

Simulate the problem here and record it.

In a thing copy, the published table has a field that is allowed to be null, and the field has a null value. Instead, the table was created in the subscription and the field is not null, resulting in the following error.

Error message: The process could not "" dbo "to the table." MyTable "" for bulk copy. (Source: MSSQL_REPL, Error number: mssql_repl20037) Get help: http://help/MSSQL_REPL20037 field size too large to get the error file that details the error encountered when initializing the subscription table, perform the bcp command. For more information about the bcp utility and the options it supports, see BOL. (Source: MSSQLServer, Error number: 20253) Get help: Http://help/20253bcp "Demo". " dbo "." MyTable "in" C:\Program Files\Microsoft SQL Server\mssql10. MSSQLSERVER\MSSQL\REPLDATA\UNC\DB_DEMO_SYNC\20160304164426\MYTABLE_2.BCP "-E" errorfile "-T" \n<x$3>\n "-r" \ n <,@g>\n "-m10000-sdb01-t-W (Source: MSSQLServer, Error number: 20253) Get help: http://help/20253

Therefore, whether the field is a null value should be consistent in the published and subscribed tables.

SQL Server process cannot bulk copy to table