On Thu, 02 Oct 2003 17:20:57 +0200, Yan Roosens
<yan.roosens@skynet.be> wrote:

>Hello all,
>
>I'm a total newbie with SQL Server 2000 and I have a little problem when
>moving a database form Access 2000 to SQL Server 2000.
>In the Access database, each table has an auto-increment field.
>After importing the tables in SQL Server, all the auto-increment fields
>are turned into "int" type fields.
>Does anybody have an explanation for that mystery?
>
>Thanks in advance,
>Yan
>
Because that isn't a data type. Look up identity for an explanation of
how sql server can provide that sort of functionality.