how to auto reset identity value

hi,

each and every time use DBCC command or turn on /off identity on column is not good idea.
if we turn on / off identity on column on every insert, than Identity doesn't make any sense.

what you think?

Instead of doing this I would suggest use normal column not use identity column. increment value of this column before inserting value.
hope this will help you.