I am replicating using transactional replication from SQL2005 to SQL2000 however the deployment of the snapshot is failing on the bulk insert of the data into the subscriber tables (works fine to a 2005 subscriber), providing the following error details:
Error 'The process could not bulk copy into table '"dbo"."tableName"'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20037)' ....
The suggestion in the error details is to run the bcp from the command line to get the error:
bcp "databaseName"."dbo"."tableName" in "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\repldata\unc\Testing1234\20091118173514\tableName_2.bcp" -e "errorfile" -t"\n\n" -r"\n<,@g>\n" -m10000 -SECM-DBOLD -T -w
This outputs:
0 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.): total 1
There are no errors outputted.
Any suggestions ?
Dave.