Snapshot replication with additional columns in subscriber

[m***@rcn.com]

I have an additional column in my subscriber table than I do in my
publisher. I can get transactional replication to work with this by
using vertical partitioning, But I can not get my snapshot to load the
table correctly. The process does not seem to fail, but the subscriber
remains empty. Any ideas would be appreciated.

[Ben Thul]

A couple of things come to mind:

1) What is the value that you provided for @pre_cmd in the call to
sp_addarticle? If you did this through the wizard, you can find the
answer in the sysarticles table at the publisher (0 = 'do nothing', 1
= 'drop', 2 = 'delete', 3 = 'truncate').
2) When you called sp_addsubscription, what did you pass in for
@sync_type? If it was 'replication support only', that's telling the
system not to do a data synchronization (i.e. that the data is already
in sync)
3) What do the snapshot files hold? That is, for the article in
question, what do the .pre, .sch, .bcp, and .idx files hold? Any one
of them could hold a clue as to what's going on (e.g. if the .bcp
files are empty, the snapshot agent isn't signifying any data to put
into the subscriber)
--
HTH,
Ben

Post by m***@rcn.com
I have an additional column in my subscriber table than I do in my
publisher.  I can get transactional replication to work with this by
using vertical partitioning, But I can not get my snapshot to load the
table correctly. The process does not seem to fail, but the subscriber
remains empty.   Any ideas would be appreciated.