Any other thoughts on resetting the Identity for this table? This is a table that holds information about Petty Cash pay outs. There really aren't that many during each month. They just like to see the reference number incremented starting at 1.

I could create another column in the table that is just a Count() + 1.