Unexpected EOF encountered in BCP data-file
George Nentidis
(Source: PTOLEMEUS (ODBC); Error number: S1000)
Hi there all.
I'm trying to install transactional replication between two DBs in the
same SQL server instance. This is for only one table.
The source and target tables have the same schema in the first 13
columns that participate in the replication. I use a row filter based
on a datetime column.
I keep getting the above error message when I start the snapshot agent
for the initial shapshot. I can't figure out what it is.
Anybody has any ideas?
Thank you all in advance
George
Paul Ibison
do you have different schemas on publisher vs subscriber (inc collation)?
If they are identical, are the collations different in the databases?
sp_helpsort for the server, but you need to check the database one :
SELECT DATABASEPROPERTYEX('yourdbname', 'Collation')
Cheers,
Paul Ibison SQL Server MVP, [url]www.replicationanswers.com[/url]
(recommended sql server 2000 replication book:
[url]http://www.nwsu.com/0974973602p.html[/url])
George Nentidis
Paul, thank you for your replay.
The schemas of the two tables are not identical.
But they are exactly the same up to the 13 fields that I want to replicate.
The collation is the same on both DBs.
My problem still remains, replication fails.
Paul Ibison
tables, and the publication and I'll take a look.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book: