View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 07:10 PM
Yan Roosens
 
Posts: n/a
Default Auto-increment fields when moving a base from Access to SQL server

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


Reply With Quote