No such data type as autonumber in SQL. What it uses instead is an integer field which is set as an Identity. IN Enterprise manager, look at your table design and click on this field. If you look at the bottom of the window there is an area which describes the details about that column definition. You will see that one of the options is Identity. It should say yes, if you want to Autonumber. If it says yes, you also need to specify the Identity seed and identity increment. The identity seed is just the number SQL would start numbering from if the table were empty. Since you have data it will start numbering from the last value unless the seed number was higher than the last value.
The identity increment is how many numbers it will increment each added record by. It is usually set to one.
Hope this helps.
