BCP error during DB Sync on Filtered Columns

Hi,
I'm have a wonderful time configuring replication on a set of tables and
need some help in diagnosing an error that is popping up.
Currently, I am using the transactional model with queued updating. I have
a set of tables that contain text columns, so during the publication build I
excluded these columns.
I then took a backup of the database and restore it at the subscriber.
When the DB's try to sync, I am getting the following error message on the
tables that have filtered columns:
'The process could not bulk copy into table 'tablename'
Unexpected EOF encountered in BCP data-file.
SQL is creating the file behind the scenes when the snapshot occurs, so I am
not directly creating a format file for it to use.
Any thoughts on how to fix this error?
the problem is because you have different schemas on your publisher and
subscriber.
You should recreate and redeploy your snapshot to fix this.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"misterkit(at)yahoo.com" <misterkit(at)yahoo.com@.discussions.microsoft.com>
wrote in message news:847D3E50-44D7-4B37-9BE4-DDF54D379844@.microsoft.com...
> Hi,
> I'm have a wonderful time configuring replication on a set of tables and
> need some help in diagnosing an error that is popping up.
> Currently, I am using the transactional model with queued updating. I
have
> a set of tables that contain text columns, so during the publication build
I
> excluded these columns.
> I then took a backup of the database and restore it at the subscriber.
> When the DB's try to sync, I am getting the following error message on the
> tables that have filtered columns:
> 'The process could not bulk copy into table 'tablename'
> Unexpected EOF encountered in BCP data-file.
> SQL is creating the file behind the scenes when the snapshot occurs, so I
am
> not directly creating a format file for it to use.
> Any thoughts on how to fix this error?