Koen Verbeeck (7/23/2013)
Maybe you can try to take a look at sequences, if avoiding gaps is important.
Sequences have the same gap-causing properties as identities (identities in SQL 2012 use the Sequence code)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability