autoID from Access to SQL7

[poohtour]

I recently had an access db up sized to SQL7. MY Access auto number field came up as int in SQL7. How can I return this field to an autonumber. I tried using uniqueidentifier but I received a message that was not allowed. I am very new to SQL7, about 2 days new.

 

[foxdev]

In the Books Online (BOL) for SQL Server, you'll find that there is not a datatype "autonumber". The equivalent is an integer data type (numeric will work, too) that has the Identity property set.
Robert Bradley

http://www.foxdev.com/

http://www.agrainofhope.org