title: Auto increment over multiple identity columns in MS SQL 2005 or 2008
body: <p>I want to have two different tables in MS SQL, for example users and groups, both with identity column. It is possible to create auto increment over two identity columns? I want to have third table with common informations to these two tables and I want to identify unique record.</p>
  
  <p>In Oracle is SEQUENCE.</p>
  
  <p>It is possible to do it?</p>
  
  <p>Thanks,</p>
  
  <p>Martin Pilch </p>