# Index problem for MS sql server 7?

**URL:** <https://forum.kirupa.com/t/index-problem-for-ms-sql-server-7/94751>\
**Category:** Uncategorized\
**Created:** [November 16, 2003, 12:04pm UTC](https://forum.kirupa.com/t/index-problem-for-ms-sql-server-7/94751 "2003-11-16T12:04:07Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![SBUH](https://avatars.discourse-cdn.com/v4/letter/s/4bbf92/32.png) [@SBUH](https://forum.kirupa.com/u/SBUH)\
**Post date:** [November 16, 2003, 12:04pm UTC](https://forum.kirupa.com/t/index-problem-for-ms-sql-server-7/94751/1 "2003-11-16T12:04:07Z")

</div>

Hello, I have the first column of the table (named “ID”) as primary key for the table, and define it as auto increased number start from 1.

So when I design the table, I set for ID column

Identity ticked Indentity seed =1 and Indentity Increase=1

But after I insert more than 10 values, the first column has some errors generated

The sequence is disordered and the records are like

1, 2, 3, 4,…11, 12, 15, 13,14 …

Does any one who could help with it? And how should I do to make the records are inserted according to the index order of 1,2 3,…

Thanks a lot in advance!