how to auto reset identity value

Apr 23 2013 7:15 AM

I HAVE CREATED IDENTITY VALUE FOR COLUMN ID IN TABLE..

IDENTITY(1,1)..

IF I DELETE RECORD ID 11..AND NEW RECORD ..ID IS TAKEN 13 NOT 12..

I USE TO RUN SQL QUERY

DBCC IDENTCHECK('TABLENAME',RESEED, 11)

EVERY TIME..

HOW TO AUTOMATICALLY RESEED COLUMN VLAUE..

Answers (2)