Quick word of caution: [font="Courier New"]TRUNCATE TABLE[/font] will reset [font="Courier New"]IDENTITY()[/font] to its original seed value. I just got burned by that feature when I used truncation instead of deletes to empty a table.

:crazy:

Great question, by the way! It's sad that we had to wait until SQL Server 2012 to get [font="Courier New"]CREATE SEQUENCE[/font]...