If I'm reading "Create Sequence" correctly, I think you'll find Identity does what you need.
Books Online has data on it at:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/8429134f-c821-4033-a07c-f782a48d501c.htm
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon