Problem with Identity Field after migration from older version of SQL

[crystalkiwibruce]

I'm trying to migrate my application database from SQL 2000 to my new SQL 2010 server. I created the new database and used the "Import" tool to select the tables in my system.

I ticked the box that said "Enable Identity Insert" so the Record ID fields that were set to AutoNumber went across with their original values.

I now want to set those fields back to being an autonumber Field so my application will work with the new database. Each time I try and modify the field, I'm getting a permission error saying I'm not allowed to make that change.

What am I doing wrong?

 

[mrdenny]

Well, first there is no such thing as SQL Server 2010, there is however SQL Server 2008 R2. How did you get the tables created?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
MCM (SQL 2008)
MVP

My Blog