First of all thank you for your replies.

1. Both servers update the email table. HR adds employee data, Campus Solutions adds student data. A student can...

When you say peer to peer replication is this the same as transactional replication mentioned above in the post? I appreciate the list of alternatives and the reasons they...

I had to check on that question. They are in our test environment but when we go to production with the split they will not be.

I also...

Transactional Replication seems like a lot of overhead to keep one table synchronized. Are there any other suggestions for keeping the tables in sync?

Thank you,

Steve

EmplIds are kept in sync by other HRSA processes. This SP only works with existing EmplIds which are synced between systems when they are created.

Looking over the Transactional Replication Overview triggered a couple of areas that I need to provide clarification.

Updates may be made in either database

If db1.tableA is updated then db2.tableA...

Good call. I was focussed on the eliminating the second left outer join for "PRI". Adding a statement like ", COALESCE(E.NAME, F.NAME) 'REPORTSTO_PRF_NAME'" within the fields portion of...