No error show up. And yes both databases may have the same primary key in some tables. I dont know what im missing here or just taking the wrong approach. This is the process i have used to replicate

------------------------------------------------------------------------------

1. Created a publication for DB1 (I created a snapshot to set up the initial sync)

2. Created a subscribtion for DB1 to point to ReplicationDB.

---Tables replicated just fine-------------------------------------

---Now need to replicate another similar database to the ReplicationDB----------

3. Created another publication for DB2 (I did not create a snap shot for this as i have already done that)

4. Created another subscription for DB2 to point to ReplicationDB.

When i leave it like this, DB2 will not replicate as it is still waiting for an initial snapshot or something to get it going. I could not find the a place to select a setting where the subscriber already had data and schema.

If i create a snapshot for DB2 it will replace all the data in ReplicatationDB and DB2 will replicate fine. But not both

I am also testing this on one server. You think that would cause any issues?.....

Again thanks in adavance for your time.....