title: best way for handling identity columns in replication
body: <p>I need to implement Merge replication with a scenario like a Central Main server, 4 Office Servers located at each country office, and each machine having sql express insatalled on them.</p>
  
  <p>Each server has SQL standard 2008 and Each client with sqlexpress will replicate data between assigned office server.</p>
  
  <p>All OFfice servers will replicate the data amonghst themselves through the central server</p>
  
  <p>What is the best way to handle Identity Columns?</p>
  
  <p>60% of tables have identity columns.</p>
  
  <p>I am worried that there will be a lot of conflict due to identity columns. What will be the best option??</p>