I'm confused ....  You want something to go from the subscriber to the publisher ??  

You're sure duplicates are not allowed at the publisher ?

No, you need to set up you snapshot articles in a snapshot publication, and your transaction articles in a transaction publication. 

BTW, When you create transaction publication, and get to the screen where...

I'm pretty sure it's not possible, using Transactional replication.  How can it perform an update if it can't use a key to find the record to be updated ??   How...

Phil's reply looks good.  I'd advise setting up some sample data in test tables before trying it on the live tables.

Here's what I run to build replication info into a table, and verify the counts between publisher & subscriber.

I use the "replication_stats" table for reference whenever I want to see...

We use replication to copy data to another database, and then users can query that other database instead of production. They only have read access, so they can select whatever...

I couldn't find anything abnormal.

I detached NEWDB1 & 2, and got login errors when I tried to reconnect with my own loging & another one.  I logged on as "SA"...

When NEWDB1 & 2 were added via the software install, I created a new global group for it and put 1 new windows login in that group, and gave that...

These are all windows accounts with SQL permissions via Active directory and Global groups.

No, the guest account is not enabled for NEWDB1 & NEWDB2

Yes, a Windows Group does have access to NEWDB1 & 2,  and separate Windows groups have access to our other...

I created a few utilities for my own use to list what tables are being replicated, including filter data, and also to verify that the record counts on the publisher...

It sounds as though "DateOfInterest" is not a datetime field.  If not, then perhaps SQL is looking at them as:

10012004 and 09302005   so the first number is actually bigger than...

Use SP_WHO2 to identify the connections. If someone opened the DB via Enterprise Manager (including you), that can often leave an open connection.

Why not just schedule it to run at those times and be done with it ??