SQL Server Express Int Pkey Auto-Increment versus SQL 2005 Identity

Discussion in 'Databases' started by Chicago_Lar, May 15, 2007.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. While researching my previous problem, I read a reply to another post that SQL 2005 does not offer the integer primary key auto-increment feature present in MS Access and SQL Express.
    </o:p>
    I wasn?t aware of this when I uploaded my aspnetdb.mdf file to DASP and attached it to my SQL 2005 database using the DASP tools.
    </o:p>
    However, the auto-increment seems to be working fine and I have made no changes to it. Does the DASP SQL Attach tool magically make some conversion from the SQL Express integer auto-increment to the SQL 2005 identity?
    </o:p>
    I?m novice at this, and simply curious, that?s all.
    </o:p>
    Thanks,
    </o:p>Lar
     
  2. Bruce

    Bruce DiscountASP.NET Staff

    No. The attach tool simply attach the database file. It should not change anything in the database schema.


    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page