Hi all,
SQL server 2000 on Windows 2003.
This is in test at the moment whilst I get to grips with replication.
I have a publication which contains numerous tables as published
articles. I'm
not ready to switch on the transacation transfer of data so have been
doing
snapshots when required. I'm now getting erros from the snapshot agent
for a
tables which don't exist in the publisher.
The process could not bulk copy out of table
'[dbo].[SYNC_XPS2SQL-BAP-Data_DESPATCH_A REA_METHOD]'.
I/O error while writing BCP data-file
The table DESPATCH_AREA_M ETHOD exists in both publisher and subscriber
and XPS2SQL-BAP-Data
is the name of the publication. The metadata is the same at both ends.
Anyone got any ideas?
Thanks in advance
Dave
SQL server 2000 on Windows 2003.
This is in test at the moment whilst I get to grips with replication.
I have a publication which contains numerous tables as published
articles. I'm
not ready to switch on the transacation transfer of data so have been
doing
snapshots when required. I'm now getting erros from the snapshot agent
for a
tables which don't exist in the publisher.
The process could not bulk copy out of table
'[dbo].[SYNC_XPS2SQL-BAP-Data_DESPATCH_A REA_METHOD]'.
I/O error while writing BCP data-file
The table DESPATCH_AREA_M ETHOD exists in both publisher and subscriber
and XPS2SQL-BAP-Data
is the name of the publication. The metadata is the same at both ends.
Anyone got any ideas?
Thanks in advance
Dave