how to change the maxium existing value on sql server?

Question

I have deleted a row in my database with the value of 8. the problem is when I add the next row the auto number starts with 9 not 8. it stills consider the maxium existing value equal to the row whivh was already deleted. how can I fix this?

Answer 1

You can use:

DBCC CHECKIDENT ('tableName', RESEED, 7);
GO