title: SQL Server 2005 - using generated sequences instead of Identity columns?
body: <p>I'm really thinking about switching away from Identity columns in SQL Server 2005 and going with some type of sequence generator (as far as I know there's nothing built in to 2005 to do this; may be coming in 2011?) to get unique id's for inserted rows.</p>
  
  <p>Is there a model implementation or best practice for this? Will I encounter locking issues? What are the down sides compared to just using Identity columns?</p>