Gaps in my key ID field

Greetings,

I am new to SQL Server. I've created a database with a key ID field that is set to automatically increment. Well, after adding records I've got some gaps in my numbering and want to renumber from 1 to eof.

What is the best way to do this in SQL Server 2005?

Thank you.

I have covered it in the thread below. Hope this helps.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2072438&SiteID=1

|||Thank you!|||

Elizabeth Davis wrote:

Thank you!

I am glad I could help.