What database server are you using? it becomes little difficult to help unless we know which database you are using. Assuming that it is SQL Server, you should be looking at DBCC CHECKIDENT