We are, however, mirroring the database within site 1. We are not mirroring at site 2. I'm thinking merge replication might be better than transactional with queued updates.

I'm seeking help from the well of SQL Server gurus on this board. My question involves using replication in SQL Server 2000. First let me give you top level overview of what I'm been asked to ...