in enterprise manager when in design mode for the table--there is an option for identity, turn it to YES then you can set the seed value.

-----Original Message-----
From: Randy Vaughn [mailto:[EMAIL PROTECTED]
Sent: Thu 5/13/2004 9:15 AM
To: SQL
Cc:
Subject: RE: Alter column to add identity


Could you go to design mode and turn identity off, make changes and then
turn back on?


-----Original Message-----
From: Robert Everland III [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 29, 2004 11:39 AM
To: SQL
Subject: Alter column to add identity


How do I alter a column that is an int so that it is also an identity? I
can't delete the column as it's an upsized access database so I need to
keep the numbers that are there.
  _____
  _____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to