What's the best way to setup the system if I have one "main" MSSQL DB and
another MSSQL DB on a remote ISP site with just a subset of tables of the
main DB but with same "Insert/Update" capabilities? The changes on either
DB needs to be replicated between the other DB.

Do I need to abandon the use of the "Identity" column on each table as primary
key since both DB "Inserts" will conflict? TIA.