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...