[dba-SQLServer] Is it possible

Hi John,

Yes, unlike Acces, in SQL Server you can switch autoincrement on and off regardless of 
whether or not there are existing records in the table.

-- 
Stuart

On 25 Feb 2011 at 21:48, jwcolby wrote:

> The upsize from Access to SQL Server is not going to be trivial.  I
> might be able to zip and upload to my office where I have servers with
> office 2003 and Windows 2008 x64 and 16 or 32 gig RAM.
> 
> However I am wondering whether it is possible to build the table
> structure of this one table over in SQL Server (express 2005) which
> (back in Access) contains an autonumber PK.  In SQL Server, remove the
> PK as well as the autoincrement property from the table.  Append the
> data into the table in SQL Server, then put the autoincrement / PK
> property back on the PK field in SQL Server.
> 
> -- 
> John W. Colby
> www.ColbyConsulting.com
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
>