converting Access databases to SQL

[Veronica]

Question:

I am in the process of converting a series of Access databases. Each databases
contains a primary key (autonum). In converting them over to SQL, does SQL
Server 7 support this feature? In not, how can I incorporate a primary key
or unique key into the databases?

Thank you for all of your help!

Veronica Lee
vlee@ascap.com

[Bruce Taylor]

Hi Veronica,

you can create a auto-incrementing in SQL Server 7 by defining an integer
data type and setting the IDENTITY attribute on the column to true. you
can access this attribute through the Enterprise Console by opening a table
in design mode.

Bruce Taylor
PriceWaterhouseCoopers

"Veronica" <vlee@ascap.com> wrote:
>
>Question:
>
>I am in the process of converting a series of Access databases. Each databases
>contains a primary key (autonum). In converting them over to SQL, does
SQL
>Server 7 support this feature? In not, how can I incorporate a primary
key
>or unique key into the databases?
>
>Thank you for all of your help!
>
>Veronica Lee
>vlee@ascap.com

[Veronica]

Thank you so much!!

Veronica

"Bruce Taylor" <bruce.a.taylor@us.pwcglobal.com> wrote:
>
>Hi Veronica,
>
>you can create a auto-incrementing in SQL Server 7 by defining an integer
>data type and setting the IDENTITY attribute on the column to true. you
>can access this attribute through the Enterprise Console by opening a table
>in design mode.
>
>Bruce Taylor
>PriceWaterhouseCoopers
>
>"Veronica" <vlee@ascap.com> wrote:
>>
>>Question:
>>
>>I am in the process of converting a series of Access databases. Each databases
>>contains a primary key (autonum). In converting them over to SQL, does
>SQL
>>Server 7 support this feature? In not, how can I incorporate a primary
>key
>>or unique key into the databases?
>>
>>Thank you for all of your help!
>>
>>Veronica Lee
>>vlee@ascap.com
>