title: Share auto-incremented primary key between two tables
body: <p>Hi I want to have two tables each have an INT "id" column which will auto-increment but I don't want either "id" columns to ever share the same number. What is this called and what's the best way to do it? Sequence? Iterator? Index? Incrementor?</p>
  
  <p>Motivation: we're migrating from one schema to a another and have a web-page that reads both tables and shows the (int) ID, but I can't have the same ID used for both tables.</p>
  
  <p>I'm using SQL Server 9.0.3068.</p>
  
  <p>Thanks!</p>